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>
