Hi all, I have done this type of setup before. There is a company that puts out a zipcode file with the Latitude and longitude in it. You can then calculate what's in the distance you are looking for.
Scott. > -----Original Message----- > From: Robert Dunlop [mailto:[EMAIL PROTECTED] > Sent: Friday, April 15, 2005 6:51 PM > To: Scott Haneda; MySql > Subject: Re: zip code search within x miles > > > I haven't looked into this recently, but as long as 15 years ago > there were > zip -> mile libraries available; I assume similar libraries still exist. > The ones I worked with all used only the first 3 digits. Full five digit > and nine digit zips get to pretty specific geographic locations, > a level of > accuracy not needed when telling people what resource exist within "x" > miles. You might try google something like: (zipcode OR zip) distance > software library > HTH > > Bob > ----- Original Message ----- > From: "Scott Haneda" <[EMAIL PROTECTED]> > To: "MySql" <mysql@lists.mysql.com> > Sent: Friday, April 15, 2005 3:37 PM > Subject: zip code search within x miles > > > > How are sites doing the search by zip and coming up with > results within x > > miles? Is there some OSS zip code download that has been created for > this? > > -- > > ------------------------------------------------------------- > > Scott Haneda Tel: 415.898.2602 > > <http://www.newgeo.com> Novato, CA U.S.A. > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]