city, state and zipcode database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
yasir15
Forum Newbie
Posts: 1
Joined: Mon Aug 16, 2004 10:31 am

city, state and zipcode database

Post by yasir15 »

Hi,

Is there a free city, state and zipcode database available for US ?
Basically what I want is that I have two drop downs, 1 for state, 2 for city.

If a state is selected, cities for that state get populated from this database.

In the same way, if a zip code is entered, both the cities and state get populated from this db.

Thanks for all the help !
User avatar
Joe
Forum Regular
Posts: 939
Joined: Sun Feb 29, 2004 1:26 pm
Location: UK - Glasgow

Post by Joe »

Im not sure if there is a database available, I think you would have to create the script manually. A good idea could be to copy and paste citys etc from another site and put it into proper functionality on your site.
User avatar
hawleyjr
BeerMod
Posts: 2170
Joined: Tue Jan 13, 2004 4:58 pm
Location: Jax FL & Spokane WA USA

Post by hawleyjr »

The USPS has a ZIP Code database that you can get. its not free however; I believe it is like $300 a year.
Post Reply