Advanced Search

Return to Snippet

Revision: 9889
at November 28, 2008 04:32 by jamesming
Initial Code 
SELECT id, place_name,
ROUND( SQRT( POW((69.1 * (#Val(arguments.latitude)# - latitude)), 2) + POW((53 * (#Val(arguments.longitude)# - longitude)), 2)), 1) AS distance
FROM places
Initial URL 
http://www.petefreitag.com/item/622.cfm
Initial Description 









Initial Title





MYSQL FORMULA TO LIST NEAREST  LOCATIONS FROM TWO GEO COORDINATES









Initial Tags














Initial Language





SQL