worldnews — 2011-01-28T00:37:47-05:00 — #1
I hope this is the right forum to post this question.
I could not see where would be better suited than here so I am posting here.
So what I am looking for is a MySQL DB, preferably free but can pay for it, that has 3 Tables:
1- All countries of the World
at least should have: ID, Country name
2- All States/Provinces of each Country, of course not all countries have states.
at least should have: ID, country_id, state_name
2- Cities of each State, can be the Top 50 or 10 cities of each state
at least should have: ID, state_id, city_name
tangledman — 2011-01-28T07:56:56-05:00 — #2
I think your best bet for this is:
worldnews — 2011-01-28T12:58:51-05:00 — #3
ThanX. But this does not give me what I need which is Country then States of that Country and then Cities of that State in a MySQL DB.
tangledman — 2011-01-31T07:58:52-05:00 — #4
I got all the provinces and all the corresponding municipalities of Spain from it.
Have a look here it tells you how to get them.
worldnews — 2011-01-31T11:43:32-05:00 — #5
I checked the URL below, but do not see where there is a Download of what I am looking for! Did I somehow miss it? If so please point me to it. ThanX.