Error Selecting Products from Data Base!
".
'Error:' . mysql_error() . '');
}
$num_rows = mysql_num_rows($listem);
if($num_rows == 0){
echo("
| No Dealers Listed |
");
}
while ($row = mysql_fetch_array($listem)) {
$name = stripslashes($row['name']);
$address = stripslashes($row['address']);
$city = stripslashes($row['city']);
$area = $row['area'];
$state = $row['state'];
$zip = $row['zip'];
$country = $row['country'];
$phone = $row['phone'];
$email = $row['email'];
$website = $row['website'];
if($area != ""){
$where = $area;
}else{$where = $city.', '.$state;
}
echo("
" .
"| $name $where |
" .
"$address, $city, $state $zip Phone: $phone
");
if($email != ""){
echo(" Email: $email");
}
if($website != ""){
echo(" Website: $website");
}
echo(" |
");
}
?>