Hello,
I have a database which has listing of canadian users. What is the best way show like users in 10, 15, 20, 02 30 miles radius after user enters the zip code in a search screen? How to find out which zip code is nearer to the zip code which user enters in a search screen? The database has data like user address including the zip codes.
Any one has developed this kind of functionality?
Thanks
MS
Subject: Zip codes difference
Try this:
http://www.emory.com/progress/canada.htm
There are other similar commercial solutions out there, all working on the same principal – a database of Postal Codes (ZIP is an American thing) along with a latitude & longitude. You enter the “home” Postal Code and a radius, and the software returns all of the Postal Codes within the radius. You then compare that list against the Postal Codes in your database (office/store locations, etc.) and return the related documents.
Subject: RE: Zip codes difference
Thanks
MS