Re: dealer locator possible?

On 10/26/00 4:09 PM this was written: > I have someone that would like to create a dealer locator on their site. > We're doing the e-commerce side in PHP and MySQL. They are planning on > providing me with an excel file with 1500 dealers. Sending a query looking > for the closest Zip doesn't sound like it would be accurate, or is it that > simple. If not, any other suggestions on services out there? There are ways to do this using Lat and long. I have a proprietary tutorial on this that I cannot give out but I see someone online has done this too. http://px.sklar.com/author.html?author_id=296 The zip code db can be found at: http://www.census.gov/ftp/pub/tiger/tms/gazetteer/ or http://www.census.gov/ftp/pub/tiger/tms/gazetteer/zips.txt This is based on Census 1990 data, Census 2000 data should be out soon (link at bottom of that site) -- Thomas Deliduka IT Manager ------------------------- New Eve Media The Solution To Your Internet Angst http://www.neweve.com/