Country and city names

[Dennis_Gull]

Hello,
A client of mine asked me if I could make a dropdown list with all the countries but theres no way Im gonna sit there and import country after country and then match each country with the cities they have
So Im just wondering if theres somewhere I can find a sql list that I can just import to my database? Im not in great need of the different cites just the countries.

Edit:
Typically I found a country list some minutes after I ask.. However still wondering if theres a list that match up countries with cities.

[Nile]

I don't think there is something like this, however you could have a site that has all the countries and cities.. Everything that your client wanted, and use the get_file_contents..
But an answer to your question: I don't think there is, No.

[boogyman]

for a list of countries see
http://snippets.dzone.com/posts/show/376
as for cities within those countries... good luck

[Dennis_Gull]

Okay I guess I use the list I got then, thanks anyways.