Nearest location using php

SELECT id, ( 3959 * acos( cos( radians(37) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(-122) ) + sin( radians(37) ) * sin( radians( lat ) ) ) ) AS distance FROM markers HAVING distance < 25 ORDER BY distance LIMIT 0 , 20;

Source: stackoverflow.com

Similar codes

1 vote167 views1 answer
Ubuntu remove temp files
Shell/Bash
5 votes135 views2 answers
How to install windows 10
Shell/Bash
15 votes129 views2 answers
View git stash without applying
Shell/Bash
0 vote132 views1 answer
Why doesn't my applications turn in spotlight search
Shell/Bash
0 vote121 views1 answer
Windows check line ending of file
Shell/Bash
0 vote125 views1 answer
How to install curl on macos
Shell/Bash
0 vote138 views1 answer
Moodle update cli
Shell/Bash
1 vote135 views1 answer
Makepkg resolve auto dependencies
Shell/Bash
0 vote125 views1 answer
How to use migrate guru plugin
Shell/Bash
14 votes123 views3 answers
Total disk space in linux
Shell/Bash