I would suggest a creative solution of stealing MapQuest's distance
calculations somehow. Or maybe just do a comparison query, like try and
match all digits of the postal code and this will be closest, then match
all but the last digit, then all but the last two, and so on, this will
give you a list of address's with increasing distance.
Adam Voigt
[EMAIL PROTECTED]
On Thu, 2002-07-04 at 15:21, Brandon Pearcy wrote:
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