GeoNames Forum

hi,

i want to build a 3 dropdown set that automatically populates the state dropdown by selecting a country and the city dropdown when selecting a state. Seems like the allcountries.zip data is what im looking for, but im not exactly sure on how to insert it into my database. I created the tables and all but i get an error that says unparseable character for column "region" and so i cant get any of the data inserted. Im using a mysql management program called DB solo 3.8.2.

Thank you for your help.

There is no column 'region' in the download files. You are possibly renaming some column, but with out more information no body will be able to help.

Marc