I have latitude and longitude and I want to pull the record from the database, which has nearest latitude and longitude by the distance, if that distance gets longer than specified one, then don’t retrieve it.
Table structure:
id
latitude
longitude
place name
city
country
state
zip
sealevel