Re: lat lon function

From: Date: Tue, 08 Apr 2003 15:58:26 +0000
Subject: Re: lat lon function
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-142895@lists.php.net to get a copy of this message
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


« previous php.general (#142895) next »