Instead of countries i want cities

Hi amazing people :)

Instead of countries list i want to change it to cities , is there a way to do so .

Thank you for your help !

Does this mean that your site will be focusing on only one country  and you just want a list of all cities in that one country ?

Yes that's right !

I dont have the answer for you, but to help you get the right answer, let me ask you, are you concerned about adding the entries? or about searching the distance between cities?

Based on a recent question of mine, i can tell you that you will want to add each city as a Predetermined Value.

It was pointed out that you may want to export your mysql DB and manually enter them in that way, and then reimport it, as using the interface in the admin panel can take a long time!  

What country will this be for? If its for a country the size of the U.S., Im hoping for your sake its cities over the size of 100k, or else you could be there for weeks putting them all in by hand...

As for searching the distance between cities, that answer alludes me as well.  The zip/postal code plugin just doesn't seem to work.

Im being forced to hire someone to try and fix/add a legitimate search option between cities and towns in a single country (just a single state, in actuality, and well over 30 kilometers apart!)

You don't need to export the database table.  You can create the list using sql queries and then run that query in the database tool; such as phpMyAdmin,

Seems very complicated hmm , i think will remove the country and leave only the city and postcode , do you think this will do the work ?

The site will be made for a city and it suburbs that's all.

I know that there are DB or lists with country, cities, zipcode(postcode) when you google for it.
Check you local chambers of commerce website.. i bet they have one

edit note: just an example http://en.wikipedia.org/wiki/List_of_United_States_cities_by_population#United_States

Lijst belgische steden :

http://0110.be/posts/SQL-bestand_met_een_lijst_van_alle_Belgische_postcodes_en_steden

 Well yes, thats true, but if you dont write mysql queries all day, then exporting it as a good idea so you can use it as a reference and to view the structure in which you need to enter new items.  Bonus!.. now you also have a backup.

is this any use ?

http://www.sqldumpster.com/databases/geographic/