fiddy Posted October 30, 2006 Share Posted October 30, 2006 Hi Friends,I am in need of the list of all the countries, states and its cities. I am looking for one which is a mysql table. Kindly help me if you have it or guide me to a URL where i can download it for free.Thanks Quote Link to comment https://forums.phpfreaks.com/topic/25569-list-of-all-countries-states-and-its-cities/ Share on other sites More sharing options...
redbullmarky Posted October 30, 2006 Share Posted October 30, 2006 not really the right place for this thread, but still:http://www.maxmind.com/app/geolitecitythat should do you. tis pretty huge and takes a chunky amount of time to get it into a DB, but by far the best (and free) one i've found so far.as for the states, i needed another file for this, but i dont have the link. do a google search for 'FIPS' and you should be able to dig up something, then use mysql to perform LEFT JOINS to match the cities to their respective county/state.[b]edit:[/b] the FIPS info is on the same site as the link i gave you.cheers Quote Link to comment https://forums.phpfreaks.com/topic/25569-list-of-all-countries-states-and-its-cities/#findComment-116671 Share on other sites More sharing options...
fiddy Posted October 30, 2006 Author Share Posted October 30, 2006 Hi Friend,Thanks a lot. Quote Link to comment https://forums.phpfreaks.com/topic/25569-list-of-all-countries-states-and-its-cities/#findComment-116677 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.