location

3 minutes read
Get a list of user who are inside the circle or square of a given latitude and longitude with given distance or radius. For example my input Lat= 75.1545 and Long = 64.7643 and distance = 10 miles. I would like to get the list of users who are inside 10 miles distance from the point 75.1545 and 64.7643. Now its possible to solve this by single Mysql query. So we need  a user  table with user name, latitude and longitude of the users address. The Mysql query that will find the closest 50 l...