RE: [PHP] lat lon function
| From: | Don Read | Date: | Tue, 08 Apr 2003 16:50:58 +0000 |
| Subject: | RE: [PHP] lat lon function | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-142913@lists.php.net to get a copy of this message | ||
On 08-Apr-2003 Edward Peloke wrote:
> Thanks, I will start to play with this, has anyone here done a query like
> this?
>
You could bracket the set of *possible* airports by :
SELECT ... FROM ...
WHERE lat BETWEEN latmin and latmax
AND lon BETWEEN lonmin and lonmax
The min/max values being calculated as 69 miles per
degree from the origin airport.
<snip>
Regards,
--
Don Read dread@texas.net
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.