oliflorence
New Member
Hi everyone,
I have been asked to write a script that will find towns within a radius of 10 miles (for instance) in a database.
I have a database of towns with their corresponding latitude and longitude and I am fine working with the database, SQl etc but I have no idea how to work the coordinates.
Does any one know how to calcuate distances using coordinates?
I have been asked to write a script that will find towns within a radius of 10 miles (for instance) in a database.
I have a database of towns with their corresponding latitude and longitude and I am fine working with the database, SQl etc but I have no idea how to work the coordinates.
Does any one know how to calcuate distances using coordinates?