 |
 |
Show distributors from which state?
if ( $_POST['sent'] == "yes" ) {
$state = $_POST['state'];
$query_raw = "SELECT * FROM distributors WHERE state='$state' ORDER BY city ASC";
$query = mysql_query($query_raw);
echo '' . $state . ' DISTRIBUTORS
';
while ( $dist = mysql_fetch_array($query) ) {
echo '';
if ( $dist['name'] ) { echo '' . stripslashes($dist['name']) . ''; }
if ( $dist['address'] ) { echo ' ' . $dist['address']; }
if ( $dist['city'] ) { echo ' '. $dist['city'] . ', '; }
if ( !$dist['city'] ) { echo ' '; }
if ( $dist['state'] ) { echo $dist['state'] . ' '; }
if ( $dist['zip'] ) { echo $dist['zip']; }
if ( $dist['phone'] ) { echo ' ' . $dist['phone']; }
if ( $dist['email'] ) { echo ' ' . $dist['email'] . ''; }
if ( $dist['website'] ) { echo ' ' . $dist['website'] . ''; }
echo ' ';
echo '----------------------------------------';
}
}
?>
|
 |