seouri (owner)

Revisions

gist: 105036 Download_button fork
public
Public Clone URL: git://gist.github.com/105036.git
Embed All Files: show embed
Text only #
raw 
1

SELECT *,(((acos(sin((".$latitude."*pi()/180)) * sin((`lat`*pi()/180))+cos((".$latitude."*pi()/180)) * cos((`lat`*pi()/180)) * cos(((".$longitude."- `lng`)*pi()/180))))*180/pi())*60*1.1515*1.609344) as distance FROM `items` ORDER BY distance;