3 levels drop down menu, countries, state/province, city

blackhorse

I want have 3 drop down menus. Country, state/province, city

1st drop down menu will list all the countries, you pick up a country, 2nd drop down menu will show the state/province of that country, then you pick up state/province, 3rd drop down menu will show the cities of that state/province.

I know the database will be huge.

1) Are there any scripts/database/list like that to show 3 levels countries, states/province, cities?

2) Are there any scripts/database/list like that just for countries and states/provices?

stolzyboy

There may be some premade ones out there... but in all reality, this is really easy to accomplish if you have the DB populated already, but even then, I'm sure you can find something out there that has this populated already.

blackhorse

It is easy to do in programming but it is too huge to build up. Say if there are 200-300 countries, every countries have 20-100 states and provinces, and every state and provinces have 30-100 or more cities and towns. Plus, keep them up to date, it is a huge work.

I think it is a good wiki project. There are so many wiki projects already. Didn't find one like this though.

stolzyboy

Populating this may be your initial problem, but I would think there are some DB's out there that already have something like this as it's done over and over and over.

Any decent relational DB will laugh at these small queries if the DBs are setup even half decent.

I mean, build country list, on change, select states/province based on country, build that list, on change, select city/town for the state.

This is trivial for PHP/(insert db here whether it's postgresql, mysql, mssql, etc...)

As far as populating, I bet if you look hard enough, there are lists you can easily construct something or parse it with PHP and make an insert script to your DB, once that's done, querying is cake.

hk123

This one http://www.geodatasource.com/world-major-cities.html is not free but it comes with ASP, .NET and PHP sample codes.

kurosaki

You can take a look at GeoDataSource's World Major Cities 2010 + Drop Down List Source Codes:

http://www.geodatasource.com/world-major-cities.html

or Countries + Regions + Cities database:

http://www.geodatasource.com/cities.html