I am having trouble implementing a zip code locator program. All of the
functions work correctly but the $sql variable.
The problem occurs by using the latitude argument as a comparison. The first
latitude argument works but when the second
latitude argument is added the query returns no data. Here is an example of
the $sql variable being used.
$sql=SELECT City FROM ZIPCodes WHERE
Latitude <= 122.02671343318
AND Latitude >= 121.96888656682
AND Longitude >= 37.617091284671
AND Longitude <= 37.508048715329;
This is the format recommended by the zip code locator develper for the sql
argument. There must be some logical way
to present this to the mysql database that will perform the latitude and
longitude comparison and retun the proper results.
A suggestion was making sure that the field is a numberic string type. I
used "Float", "Decmial", "Double" and "CHAR" the result was the same. Please
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php