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 :p
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.