RE: [PHP] lat lon function
| From: | (Edward Peloke) | Date: | Tue, 08 Apr 2003 16:17:55 +0000 |
| Subject: | RE: [PHP] lat lon function | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-142899@lists.php.net to get a copy of this message | ||
Thanks, I will start to play with this, has anyone here done a query like
this?
Thanks,
Eddie
-----Original Message-----
From: Marek Kilimajer [mailto:kilimajer@webglobe.sk]
Sent: Tuesday, April 08, 2003 11:58 AM
To: Edward Peloke
Cc: Php-General@Lists. Php. Net
Subject: Re: [PHP] lat lon function
you can use math functions built into mysql -> SIN(), COS() ....
Edward Peloke wrote:
>Hello all,
>
>I currently have a php function that takes two airport codes and returns
>their distance in miles. The function gets the longitude and latitude for
>the airports from a mysql db. My current problem is I have to show the
user
>all airports within a certain mile radius of the one they selected. I
can't
>run this function against all 7000+ rows in the db and return only the ones
>needed, how can I do this? I know I have seen this several places online.
>
>Thanks,
>Eddie
>
>
>
>