Showing posts with label longitude and latitude distance calculator. Show all posts
Showing posts with label longitude and latitude distance calculator. Show all posts

Thursday, June 16, 2011

Calculate the distance using lattitude, longitude and ZIP codes in MySQL

So, assuming we have a table:

ZIP_CODES
zip_code | lattitude | longitude

We take this zip code from NY
$zip = 10001
$lat = 40.750742
$lon =-74.52976

What we need is the Earth radius (6371 km).

If we need to search the zip codes that are in a 10 km area, we could use this 'small' sintax: