I want the user to enter their full address including a dropdown list of countries and cities that are updated based on the country selected.
Do I really have to manual create a country database table as well as all possible cities table and then make a giant php check to match the two?
I am sure there is a smarter way of doing it, but I could not seem to find one! Later I will be using the country and city to filter the results that are displayed on the page.
Any help is much appreciated!
search search search
goto http://www.geonames.org you can find complete list of cities in the world
In particular, you can search over the dump list.