/SQL/Php get closest location by latitude longitude

Php get closest location by latitude longitude

SELECT * , (3956 * 2 * ASIN(SQRT( POWER(SIN(( $lat - LatOnTable) *  pi()/180 / 2), 2) +COS( $lat * pi()/180) * COS(LatOnTable * pi()/180) * POWER(SIN(( $long - LongOnTable) * pi()/180 / 2), 2) ))) as distance  
from yourTable  
having  distance <= 10 
order by distance

Source: stackoverflow.com

Similar codes

1 vote212 views2 answers
Sql select only first occurrence
SQL
0 vote277 views1 answer
Sql server query all database objects
SQL
0 vote229 views1 answer
How we can perform acid Operations in sql with examples
SQL
2 votes216 views4 answers
Duplicate record mysql
SQL
0 vote264 views1 answer
Pl sql join 3 tables
SQL
5 votes232 views1 answer
Oracle nls session
SQL
0 vote235 views1 answer
Sql server rtrim everything after character
SQL
0 vote392 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote213 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
10 votes254 views6 answers
Mysql set root password
SQL