I'm looking for a program (php/mysql) to search within a certain radius of a zip code. Any suggestions?
My client has a database of retail stores in many cities. The website visitor would enter a zip code, select a category (clothing, furniture, etc.) and a list of stores within a certain radius of that zip code is created. This isn't something I can produce because the program must "know" what zip codes are near each other.
There are several ready-made scripts that will do this (for example: http://www.code322.com
) but my client would like visitors to have the option of entering a zip code or city name. I can't find a program that accepts zip codes or city names, only zip codes.
See Wedding Wire for an example of this search function: http://www.weddingwire.com/