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:lists@stripped]
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/mysql?unsub=1
