Mike Blezien wrote:
Chris,
this is something very similar to what we are attempting to accomplish:
http://www.papajohnsonline.com/restlocator/RestaurantLocator
The math in the link I gave you will still work for the distance
calculations, however if you want what that site does you will need
General List"
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
MySQ
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
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 :)
[/snip]
We have started storing latitude and longitude coordinates on our
databases which lends itself to distance calculations. For exampl
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 :)
TIA,
Mike(mickalo)Blezien
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
