Audiogon, why not grab the latitude and longitude associated with a zip code when a seller inserts an item for sale into the database. For instance, my zip code is 19144, so if I were to sell something, the Audiogon backend software would so out to http://www.census.gov/cgi-bin/gazetteer?zip=19144 and retrieve the latitude and longitude (40.033773 N, 75.173099 W in my case) and put it in two extra fields in the database. Then, if you do a search from a particular zip code, look up that zip codes lat/long, calculate the criteria of latitude and longitude that would fall in that radius, and query the database for items with lat/long that match that criteria.
Hopefully med school hasn't fried my brain too much so I can still remember enough from my software engineer days.
Michael
Hopefully med school hasn't fried my brain too much so I can still remember enough from my software engineer days.
Michael