Mike Blezien wrote:
Chris,
this is something very similar to what we are attempting to accomplish:
http://www.papajohnsonline.com/restlocator/RestaurantLocator
The math in the link I gave you will still work for the distance
calculations, however if you want what that site does you will need a
GIS database that can give you lat long of an address. I am about 90%
sure something like that is going to cost you a lot of money and cost a
lot to keep it up to date. I'm afraid I don't know where to look for a
vendor though. I would search for GIS software or maybe contact some of
the mapping people like Google maps or Street Atlas USA, if they don't
have a product they can sell you to provide lat long of street
addresses, maybe they can tell you who provides them with data and
contact them.
--
Chris W
KE5GIX
Gift Giving Made Easy
Get the gifts you want &
give the gifts they want
One stop wish list for any gift,
from anywhere, for any occasion!
http://thewishzone.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
