Dealers in ' . $stateFull . ':

'; $getResults = mysql_query("SELECT * FROM dealers WHERE state = '$state' ORDER BY city ASC") or die(mysql_error()); if(mysql_num_rows($getResults) == 0) { $display .= 'No dealers were found in ' . $stateFull . '. Please try another state or province.'; }else{ while($result = mysql_fetch_array($getResults, MYSQL_ASSOC)) { $display .= '
'; $display .= '' . $result['dealer_name'] . '
' . $result['address'] . '     ' . $result['city'] . ', ' . $result['state'] . ' ' . $result['zip'] . '
' . $result['phone'] . ' phone
' . $result['fax'] . ' fax
'; if($result['email'] != '') { $display .= '' . $result['email'] . '
'; } $display .= '
'; } } $display .= '
'; }else{ } print $display; ?>


« Go Back