Hi, I'm sure one of you has come across this problem sometime in your programming career. It seems to be an absolute pain trying to find anything on the net though. Basically I'm after 3 tables containing all the country/state/city data in the world: countries (country_id, country_name) states (state_id, state_name, country_id) major cities (city_id, city_name, country_id, state_id) Which I would then put into 3 combo boxes and have them dependent on each other: The user selects a country, I use ajax to grab the states for that country. User selects a state, I use ajax to populate the city combo box with the cities in the state. User selects the city, then submits the form. Ok so I've got a rough idea what the code will look like from here however I'm missing all the data to make this happen. So far I've got a list of all the timezones and countries with international dialing code prefixes i.e. +61 for Australia (I had to format myself from some pdf file). Some sites have a list of the countries and cities, but no state data. Is there a free web service you can use to query for this information? From my readings so far it looks like a database doing this could be upwards of 80MB. Could slow down my web server quite a bit... I'm using PHP and MySQL by the way. Many thanks!