""Mike Blezien"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> 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 t
-
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
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
