countries and cities list

[DYLG]

Hi!

I know this is not a php related question but I need to reach many of you guys.

I'm looking for data that I could insert into a mysql DB. I need a list of all countries, all states in each country and all cities in all states or countries. I know that such list exist but I can't find any.

Thanks you in advance for any help!

[planetsim]

You may wanna search Google

[DYLG]

I search google for 2 hours, didn't found anything.

[tomhath]

Don't know if this is exactly what you need, but the source of the information is pretty cool: 🆒

http://www.cia.gov/cia/download.html