I need a database of Countries and their Cities.
any idea where i can get it. or any one can share it with me ?
Like this http://www.worldcitiesdatabase.com/world-cities.aspx
I need a database of Countries and their Cities.
any idea where i can get it. or any one can share it with me ?
Like this http://www.worldcitiesdatabase.com/world-cities.aspx
Check this out:
Cities of the world database donated by MaxMind.com
The company MaxMind.com1 has agreed to release their cities of the world database under the GPL. The database contains locations by country, city, latitude and longitude. There are over 3,047,000 records in the database. For those of you who have tried the location.module with the zipcodes database from CivicSpace, you will recognize how cool it is and how well this fits with that project and therefore Drupal.
Here's another free one that might help you get started.
Creating and maintaining such a database is quite a bit of work - so anyone who's done it is likely keeping it to themselves, or offering it for a fee.
There are quite a few available.
The following has database for 2,401,039 cities