michaelaguiar/distance.sql

Created October 5, 2011 00:22

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/michaelaguiar/1263246.js"></script>
Save michaelaguiar/1263246 to your computer and use it in GitHub Desktop.

Download ZIP

SQL - Calculate Distance

Raw

distance.sql

SELECT *,(((acos(sin((".$latitude."*pi()/180)) * sin((`Latitude`*pi()/180))+cos((".$latitude."*pi()/180)) * cos((`Latitude`*pi()/180)) * cos(((".$longitude."- `Longitude`)*pi()/180))))*180/pi())*60*1.1515) as distance FROM `TABLE` HAVING distance <= ".$distance;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment