Re: Maps / Distance / GeoCoding [php/mysql]

[Nathan Rixham <nrixham@xxxxxxxxx>]

Nathan Rixham wrote:
> re: an earlier thread
[snip]

or you may just need this bit:

distance =
ACOS( 
SIN(Y(g.geopoint)*pi()/180)*SIN(Y(l.point)*pi()/180) 
         +COS(Y(g.geopoint)*pi()/180)*COS(Y(l.point)*pi()/180)
*COS((X(l.point)-X(g.geopoint))*pi()/180))*6372.795

used to calc the distance between two points on the surface of the earth 
accurately

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php