http://www.totalscripts.com/pages/Perl_Scripts/Calculator/
GeoZip... only for US postcodes tho.. but is ur US fine ;) > -----Original Message----- > From: Brandon Pearcy [mailto:[EMAIL PROTECTED]] > Sent: 04 July 2002 4:34 PM > To: [EMAIL PROTECTED] > Subject: [PHP] Postal / Zip Code Proximity Search > > > Hello, > I have a couple of questions with respect to creating a postal / > zip code proximity search that is remotely accurate. The system I am > using now is OK for small distances, but is terrible at calculating > large distances. > > What I have is a database of establishments and their > corresponding > latitudes and longitudes, and I need to have users enter their own > postal / zip code, and have the system calculate which establishments > fall into a set range ($range) from their location. Not only does it > need to find the establishments, it needs to calculate the distances > (straight line, of course). > > Now, I have dug through the PHP archives, but there is no single > clear explanation of how to do this, from beginning to end. I will > start by putting down what I need, and then maybe other people can > contribute to this and in the end we will have the solution, nice and > tidy, in one place. > > *** NOTE: I know doing this in PHP will be SLOW, but I do not want to > write a MySQL user-defined function and recompile it and blah, blah, > blah... (unless someone wants to cover that aspect!!! :D) > > Step 1: Take the postal / zip code that the user entered, and > search the national postal / zip code database (which I already have) > and return its corresponding latitude and longitude ($userLat and > $userLong). > > Step 2: ??? > > Step 3: Return the establishments information to the user, > complete > with the distances to them, ordered by smallest distance to largest. > > > > If you can't help me out, maybe you can direct me to some online > tutorials on this topic! > > Thanks in Advance! > -- > -------------------------- > Brandon Pearcy > Internet Technician > > Bowes Online > -------------------------- > phone: 1-780-532-1110 ext. 265 > fax: 1-780-532-2120 > [EMAIL PROTECTED] > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
