JeremyL - 9:08 pm on Jul 17, 2005 (gmt 0)

Yea, but those are still really old. I ended up just purchasing a db from the one rusty recommended. For only a few bucks, there is no reason not to buy one that is up to date. I'll let you all know if I find it wasn't worth the cash.

Also on the slow aspect, I tried a few different distance calc functions and most where slow,but I found one here [micahcarrick.com...] that can pump out all zips within 100 miles of Dallas in half a second and all zips within 1000 miles in 2 secs.

I read some places that the speed can be increased even more by having the database itself do the calcs, but I haven't gotten that deep into MySQL to be able to do that yet.

The information I have gotten will also allow me to run the calcs by city name, but that needs to wait until my buisness database is properly populated because there will need to be some decent coding to catch mispellings of city names and the ability to suggest the correct ones. I know I can't spell so I can't expect my visitors to :D