Chris,
this is something very similar to what we are attempting to accomplish:
http://www.papajohnsonline.com/restlocator/RestaurantLocator
Mike
----- Original Message -----
From: "Chris W" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>; "MYSQL General List"
<mysql@lists.mysql.com>
Sent: Sunday, August 20, 2006 8:59 PM
Subject: Re: Calculation distances
Mike Blezien wrote:
Hello,
we are working on a small project which needs to calculate the closest
distances
from an address and/or zipcode entered into a search box. It will read from a
MySQL database of companies, which store their address and zipcodes.
looking for the best way to approach this. I've seen some zipcode Perl
modules on
Cpan, but nothing for helping calculation distances. Can someone point me in
the
right direction to accomplish this ... thx's :)
The zip code tables usually give a lat long location somewhere near the center
of that zip code (which can be HUGE in rural areas) You can then use some math
that with give you the distance between the coordinates of 2 zip codes. Here
is a web site I found for help when doing similar calculations. Remember that
this type of math usually wants angle measurements in radians, not degrees.
http://williams.best.vwh.net/avform.htm
--
Chris W
KE5GIX
Gift Giving Made Easy
Get the gifts you want & give the gifts they want
One stop wish list for any gift, from anywhere, for any occasion!
http://thewishzone.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
