Re: PHP and Mysql help
| From: | Colin Busby | Date: | Sun, 24 Apr 2005 23:42:16 +0000 |
| Subject: | Re: PHP and Mysql help | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-39269@lists.php.net to get a copy of this message | ||
Hey,
That is a lot of code, so I only skimmed it, but right off the bat i noticed that you are missing a space in between WHERE and zg_zipcode, as shown below:
$res = mysql_query("SELECT ZG_LATITUDE, ZG_LONGITUDE FROM zip_code wherezg_zipcode = '$zip'");should be:
$res = mysql_query("SELECT ZG_LATITUDE, ZG_LONGITUDE FROM zip_code WHERE zg_zipcode = '$zip'");I hope this helps... - Colin Busby --- Colin Busby Sackville, NB Canada http://www.colinbusby.ca On 24-Apr-05, at 7:54 PM, ReClMaples wrote:
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 <= $Lon2"); if (!$zipcode) { 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>"); } 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?