Zipcode Dealer Locater

[Guest]

I am trying to set up a dealer locater on our site.  My understanding is this is all math but I am confused.  I have db1 with all the zipcode information for the US in it, with the corresponding lat/long.  DB2 will have all information of my dealers in it and their location based on lat/long.  I do not understand how to take in a user supplied mileage number (5 miles, 10 miles, 25 miles, etc) and zipcode, query db1 to get the appropriate ranges that I need to query in DB2.  Please help, I have looked online and I am very confused.

[Guest]

Any help would be most appreciated.

[BKBK]

What you have is clear: US zipcodes and corresponding latitudes/longitudes, and dealer location. What you want remains unclear. What do mean by mileage number and appropriate range?

[Tim Cunningham]

Ben Nadel blogged how to get approx distance if you have the latitude and longitude of two locations, let me know if that helps:

http://cfml.us/QY

Thanks,

Tim Cunningham

[Guest · Accepted solution]

Thanks Tim, I found this article/post of Ben's and got it working:

http://www.bennadel.com/blog/1490-Using-A-Rough-Box-Model-To-Gather-Near-By-Zip-Codes.htm

[Tim Cunningham]

Ben Nadel is THE man.