al Message-
> From: AdminHMO [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 23, 2003 1:32 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] mysql field not resolving comaparison condition
> for zip code locator
>
>
> Thanks Jennifer,
>
> I got the query
AND Longitude >= 37.508048715329;
Jim
---Original Message---
From: AdminHMO
Date: Tuesday, September 23, 2003 13:35:31
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql field not resolving comaparison condition for
zip code locator
Thanks Jennifer,
I got the query and the zipc
Thanks Jennifer,
I got the query and the zipcode longitude and latitude from the developer of
the zipcode locator. When I contacted them about this issue they had me run
this query in the phpMyAdmin against the zipcode date and I still got no
data returned.
"Jennifer Goodie" <[EMAIL PROTECTED]> w
>
> 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
Thanks for the suggestion but the quotes didn't make a difference I
submitted the sql though php myadmin that takes care of the quote syntax
"Peter Beckman" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
> On Tue, 23 Sep 2003, AdminHMO wrote:
>
> > I am having trouble implementing a
On Tue, 23 Sep 2003, AdminHMO wrote:
> I am having trouble implementing a zip code locator program. All of the
> functions work correctly but the $sql variable.
Try putting the SQL in quotes:
$sql = "SELECT City FROM ZIPCodes WHERE Latitude <= 122.02671343318 AND
Latitude >= 121.96888656682 A
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
