Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
yasir15
Forum Newbie
Posts: 1 Joined: Mon Aug 16, 2004 10:31 am
Post
by yasir15 » Mon Aug 16, 2004 10:31 am
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 !
Joe
Forum Regular
Posts: 939 Joined: Sun Feb 29, 2004 1:26 pm
Location: UK - Glasgow
Post
by Joe » Mon Aug 16, 2004 10:34 am
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.
hawleyjr
BeerMod
Posts: 2170 Joined: Tue Jan 13, 2004 4:58 pm
Location: Jax FL & Spokane WA USA
Post
by hawleyjr » Mon Aug 16, 2004 11:47 am
The USPS has a ZIP Code database that you can get. its not free however; I believe it is like $300 a year.