Determining Distance With Latitude and Longitude in MySQL

Determining Distance With Latitude and Longitude in MySQL

Coding
When I was programming an application for a marketing company trying to determine where the greatest concentration of registrars where, it made sense to compare the distance from our home base, and with, at the time, release of the Google Maps API, we where able to plot those locations on the map and at the same time sort them by distance (from closest to farthest). System Requirements To get things started, here is what we need: A server with PHP (5 or newer, but not necessary) and MySQL (again newer the better). A zip code database with both latitude and longitude attached to the zip codes Optional: A Google Maps key. We have the server. The zip code database we purchased from http://www.zipcodedownload.com/ with the premium or better having the…
Read More