Hi Gerald
this is something very similar to what we are attempting to accomplish:
http://www.papajohnsonline.com/restlocator/RestaurantLocator
same sort of setup. Any type of an example would be much appreciated and maybe
get me in the right direction :)
Mike
----- Original Message -----
From: Gerald Host
To: Mike Blezien
Cc: Perl List
Sent: Sunday, August 20, 2006 9:27 PM
Subject: Re: Calculation distances
1. use one of the geocoding modules to get the latitude and longitude of the
company addresses.
2. use the same module to get the address in the search box
3. find the difference (you'll want to use ABS in the SQL for absolute values
because of negative numbers)
4. convert the difference to miles
HTH, if you need an example I can share some code with you.
Ryan
On 8/20/06, Mike Blezien < [EMAIL PROTECTED]> 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 modules on
Cpan, but nothing for helping calculation distances. Can someone point me
in the
right direction to accomplish this ... thx's :)
Mike(mickalo)Blezien
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
