Can someone help me out with an issue I'm having?

Here is my code:

$res = mysql_query("SELECT ZG_LATITUDE, ZG_LONGITUDE FROM zip_code
wherezg_zipcode = '$zip'");

List($Lat,$Lon) = mysql_fetch_row($res);

$Lat1 = ($Lat-2);

$Lat2= ($Lat+2);

$Lon1= ($Lon-2);

$Lon2= ($Lon+2);

//echo ($Lat1);

//echo ($Lat2);

//echo ($Lon1);

//echo ($Lon2);

$zipcode = mysql_query(

"SELECT * FROM zip_code where ZG_LATITUDE >= $Lat1

and ZG_LATITUDE <= $Lat2 and ZG_LONGITUDE >= $Lon1 and ZG_LONGITUDE <=


if (!$zipcode) {

echo("<P>Error performing query: " .

mysql_error() . "</P>");



while ( $row = mysql_fetch_array($zipcode) )


echo("<b>City: </b>" . $row["ZG_CITY"]. "<br>");

echo("<b>State: </b>" . $row["ZG_STATE"]. "<br>");

echo("<b>Zip Code: </b>" . $row["ZG_ZIPCODE"]. "<br>");

echo("<b>Area Code: </b>" . $row["ZG_AREACODE"]. "<br>");

echo("<b>County FIPS: </b>" . $row["ZG_COUNTY_FIPS"]. "<br>");

echo("<b>County Name: </b>" . $row["ZG_COUNTY_NAME"]. "<br>");

echo("<b>Time Zone: </b>" . $row["ZG_TIME_ZONE"]. "<br>");

echo("<b>Day Light Savings?: </b>" . $row["ZG_DST"]. "<br>");

echo("<b>Latitude: </b>" . $row["ZG_LATITUDE"]. "<br>");

echo("<b>Longitude: </b>" . $row["ZG_LONGITUDE"]. "<P>");


I get no results with this still, it acutally doesn't even go to the this

page. When I uncomment out:

//echo ($Lat1);

//echo ($Lat2);

//echo ($Lon1);

//echo ($Lon2);

and comment out everything below this, I get the expected results for

$Lat1,$Lat2,$Lon1, and $Lon2. So I have to believe my issue is below those

lines, can anyone see what I have that is incorrect here?

Reply via email to