|
Membership Directory
Click on any listing below for more detailed information about a member.
if (!$id) { ?>
mysql_connect('db.netdoor.com','lawrencecounty','sam42iam') or die ("Problem connecting to DataBase");
$sql = "SELECT * FROM members ORDER BY business ASC";
$result = mysql_db_query("lawrencecounty", $sql);
if ($result) {
echo "";
//$bg1 = "#dddddd"; $bg2 = "#eeeeee";
while ($r = mysql_fetch_array($result)) {
//$bgcolor = $bg1; $bg1 = $bg2; $bg2 = $bgcolor;
$id = $r["id"];
$name = $r["name"];
$last_name = $r["last_name"];
$business = $r["business"];
$mailing_address = $r["mailing_address"];
$city = $r["city"];
$state = $r["state"];
$zip = $r["zip"];
$physical_address = $r["physical_address"];
$email = $r["email"];
$web_site = $r["web_site"];
$phone = $r["phone"];
$fax = $r["fax"];
?>
| echo $business;?> |
} echo " ";
}
?>
} else { ?>
mysql_connect('db.netdoor.com','lawrencecounty','sam42iam') or die ("Problem connecting to DataBase");
$sql = "SELECT * FROM members WHERE id like '$id'";
$result = mysql_db_query("lawrencecounty", $sql);
if ($result) {
//echo "";
//$bg1 = "#dddddd"; $bg2 = "#eeeeee";
while ($r = mysql_fetch_array($result)) {
//$bgcolor = $bg1; $bg1 = $bg2; $bg2 = $bgcolor;
$id = $r["id"];
$name = $r["name"];
$last_name = $r["last_name"];
$business = $r["business"];
$mailing_address = $r["mailing_address"];
$city = $r["city"];
$state = $r["state"];
$zip = $r["zip"];
$physical_address = $r["physical_address"];
$email = $r["email"];
$web_site = $r["web_site"];
$phone = $r["phone"];
$fax = $r["fax"];
?>
Member Information:
if ($business) { echo $business . " ";}?>
if ($mailing_address) { echo $mailing_address . " ";}?>
if ($physical_address) { echo $physical_address . " ";}?>
echo $city;?>,
if ($name) { echo "Contact: ". $name. " " . $last_name . "
";}?>
if ($phone) { echo "Phone: " . $phone . " ";}?>
if ($fax) { echo "Fax: " . $fax . " ";}?>
if ($email) { echo "E-mail: " . $email . " ";}?>
if ($web_site) { echo "Web Site: " . $web_site . " ";}?>
}
}
?>
View All Members
} ?>
|