We convert the zip code into a Lat and long. Run the math looking for all other zips in that area, then convert that back to lat long for a mileage calculation of each.
I know there's a better way to do this we just haven't seen the benefit in rewriting it now. Watch PHP a lot of this in coming out in functions, and Perl already has some functions to do this I believe you just need the db. Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183 -----Original Message----- From: Scott Haneda [mailto:[EMAIL PROTECTED] Sent: Friday, April 15, 2005 4:38 PM To: MySql 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]