PHP and MySql question

Hello, I'm kinda new at PHP programming with MySQL. I am having an issue and am not sure if this is the corret way to do this: Here is my code, I'll start there: <?php $Lat1 = mysql_query( "SELECT (ZG_LATITUDE-2) FROM zip_code where zg_zipcode = '$zip'"); if (!$Lat1) { echo("<P>Error performing query: " . mysql_error() . "</P>"); exit(); } $Lat2 = mysql_query( "SELECT (ZG_LATITUDE+2) FROM zip_code where zg_zipcode = '$zip'"); if (!$Lat2) { echo("<P>Error performing query: " . mysql_error() . "</P>"); exit(); } $Lon1 = mysql_query( "SELECT (ZG_LONGITUDE-2) FROM zip_code where zg_zipcode = '$zip'"); if (!$Lon1) { echo("<P>Error performing query: " . mysql_error() . "</P>"); exit(); } $Lon2 = mysql_query( "SELECT (ZG_LONGITUDE+2) FROM zip_code where zg_zipcode = '$zip'"); if (!$Lon2) { echo("<P>Error performing query: " . mysql_error() . "</P>"); exit(); } $ZipCode = mysql_query( "SELECT * FROM zip_code where ZG_LATITUDE >= '$Lat1' and ZG_LATITUDE <= '$Lat2' and ZG_LONGITUDE >= '$Lon1' and ZG_LONGITUDE <= '$Lon2'"); if (!$Zipcodesearch) { echo("<P>Error performing query: " . mysql_error() . "</P>"); exit(); } 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>"); } ?> Basically I'm trying to have a user input a zip code and then have a php script pull all zip codes that are in a region of that submitted zip code. Can you have a look at my code and see what I'm doing wrong? When using this it returns no results but makes the connection to the database so I have to believe that it's within here that I have my issue. I have Apache/2.0.47 (Win32) PHP/4.3.9 Server and MySql 4.0.14 (I know I can upgrade and be able to do subselects but I would like to know what I'm doing wrong here. Thanks in advance for any help. Thanks -rich