Even better we have ISO related codes down to city level ... and download-able in different formats.

http://www.unece.org/cefact/locode/

Same and as MySQL download but regions in 2 char alpha-numerics.

Thanks for reply. So we have a list of all cities and positional data (guessing) which is helpful.

Not wanting to redo a wheel that must have been done many...

http://27.org/isocountrylist/

download the http://27.org/isocountrylist/iso_country_list.sql

load into vim editor and save

fire this at your sql database and your off

currently looking for regions (subdivisions) and cities sql tables?