I have a database with certain locations, and their corresponding latitude and longitude fields. These are expressed in decimal format.
I want to create a PHP program or SQL query, in order to know which of these locations are within an X radius from a source point.
I will tell the program my current latitude and longitude (decimal) and a radius like "1 kilometer". I want to know which locations in the DB are inside that radius.
Thanks a lot!!