How to calculate distance using lattitude and longitude

Hello,
I'll try to explain as best as I can.

I got LAT and LONG of an address.
I have another LAT and LONG for a different address, which is within 10 miles from the first one.
I have a third LAT and LONG for a different address, which is within 20 miles from the first one.
They are all stored in a mysql table.
My table looks like this:

id, LATI, LONGI, ADDRESS

I need to return the address which is within 10 miles from the first one. What query should I use?
The query should only return...

How to calculate distance using lattitude and longitude

from PHP http://ift.tt/1NurUN1
via IFTTT
Previous
Next Post »
Thanks for your comment