I’m new to php/mysql but I am trying to have the user enter a zip code and retrieve all the dealers in a 100 miles radius of that zip. I have a table with dealer names and zip codes and a table with zip codes and longitude and latitude. On the page previous to this one there is a form called dealerZip. Here the data is sorted by the form variable dealerZip.
<?php require_once('Connections/dealerConnection.php'); ?>
<?php
$currentPage = $HTTP_SERVER_VARS["PHP_SELF"];
$maxRows_rsDealer = 100;
$pageNum_rsDealer = 0;
if (isset($HTTP_GET_VARS['pageNum_rsDealer'])) {
$pageNum_rsDealer = $HTTP_GET_VARS['pageNum_rsDealer'];
}
$startRow_rsDealer = $pageNum_rsDealer * $maxRows_rsDealer;
$colname_rsDealer = "1";
if (isset($HTTP_POST_VARS['dealerZip'])) {
$colname_rsDealer = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['dealerZip'] : addslashes($HTTP_POST_VARS['dealerZip']);
}
mysql_select_db($database_dealerConnection, $dealerConnection);
$query_rsDealer = sprintf("SELECT * FROM tblDealer WHERE dealerZip = %s ORDER BY dealerCity ASC", $colname_rsDealer);
$query_limit_rsDealer = sprintf("%s LIMIT %d, %d", $query_rsDealer, $startRow_rsDealer, $maxRows_rsDealer);
$rsDealer = mysql_query($query_limit_rsDealer, $dealerConnection) or die(mysql_error());
$row_rsDealer = mysql_fetch_assoc($rsDealer);
if (isset($HTTP_GET_VARS['totalRows_rsDealer'])) {
$totalRows_rsDealer = $HTTP_GET_VARS['totalRows_rsDealer'];
} else {
$all_rsDealer = mysql_query($query_rsDealer);
$totalRows_rsDealer = mysql_num_rows($all_rsDealer);
}
$totalPages_rsDealer = ceil($totalRows_rsDealer/$maxRows_rsDealer)-1;
$maxRows_rsZip = 100;
$pageNum_rsZip = 0;
if (isset($HTTP_GET_VARS['pageNum_rsZip'])) {
$pageNum_rsZip = $HTTP_GET_VARS['pageNum_rsZip'];
}
$startRow_rsZip = $pageNum_rsZip * $maxRows_rsZip;
$colname_rsZip = "1";
if (isset($HTTP_POST_VARS['dealerZip'])) {
$colname_rsZip = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['dealerZip'] : addslashes($HTTP_POST_VARS['dealerZip']);
}
mysql_select_db($database_dealerConnection, $dealerConnection);
$query_rsZip = "SELECT * FROM ZipCode WHERE ZipCode = %s";
$query_limit_rsZip = sprintf("%s LIMIT %d, %d", $query_rsZip, $startRow_rsZip, $maxRows_rsZip);
$rsZip = mysql_query($query_limit_rsZip, $dealerConnection) or die(mysql_error());
$row_rsZip = mysql_fetch_assoc($rsZip);
if (isset($HTTP_GET_VARS['totalRows_rsZip'])) {
$totalRows_rsZip = $HTTP_GET_VARS['totalRows_rsZip'];
} else {
$all_rsZip = mysql_query($query_rsZip);
$totalRows_rsZip = mysql_num_rows($all_rsZip);
}
$totalPages_rsZip = ceil($totalRows_rsZip/$maxRows_rsZip)-1;
$queryString_rsDealer = "";
if (!empty($HTTP_SERVER_VARS['QUERY_STRING'])) {
$params = explode("&", $HTTP_SERVER_VARS['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_rsDealer") == false &&
stristr($param, "totalRows_rsDealer") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_rsDealer = "&" . implode("&", $newParams);
}
}
$queryString_rsDealer = sprintf("&totalRows_rsDealer=%d%s", $totalRows_rsDealer, $queryString_rsDealer);
?>
