zip codes for database?

Anon

generating a review database that is dependent on the closest city and I want to set it up based on zip codes rather then trusting the users to spell/enter the city correctly.

anyone have an idea on how to obtain/generate a database of zip codes/cities for the US OR, how to query another site (www.usps.com) for such information?

anyone out there set this up (like at gotocity.com, and several other sites around 'the net').

Anon

I've looked for this and could not find it either, just :

http://www.framed.usps.com/ncsc/lookups/lookup_ctystzip.html

Part of the reason I think is some zipcodes have multiple towns (small ones) but if one adds their address, "it" should know, right? Imagine if this existed, we wouldn't have to fill out/require city/state inputs anymore and that would be wonderful. Once one enters a zipcode, if multiple cities exist it should automagically give a select list for the user to select their city. This would be so nice.

Anyway, going back to the above like, through some trickery it could be done but having an actual db with this information would be much much better. Hmmmmmmmmmm...

Anon

i am curious now how tim perdue did this on gotocity.com??

would be a really nice feature but just not sure, maybe we should contact him (http://www.phpbuilder.com/contact.php3?contact=tim_at_phpbuilder.com) if he isn't reading this board.

/frank