RE: [PHP] Determining Nearest Location by Zip Code

Gotta give Thomas Deliduka props for this one. I found it very interesting. Please read below pasted email. ---- Snip Snip Snip ---- * > 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 ---- Snip Snip Snip ---- > -----Original Message----- > From: Ben Weinberger [mailto:ben@digitalsmiths.com] > Sent: Monday, November 20, 2000 3:14 PM > To: php-general@lists.php.net > Subject: [PHP] Determining Nearest Location by Zip Code > > > Hi~ > I was wondering if anyone has played with or developed a script > that allows > someone to input a zip code. It will then perform a query that checks a > specified radius (say 50 miles) and return results of all the entries in > your MySQL db that fall within that radius based on zip code. So, let's > say you had a list of shops across the U.S. You want someone to > be able to > enter their zip and it will tell them the shops closest to them > or within a > specified radius.... > > Anyone have ideas on how to do this? > > Thanks, > -Ben > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >