Get City Names of a Country/State

On Lot of websites we select country from a select list and next select list shows us the list of cities of that country. I have am trying to search method provided by any api which gives the name of cities when I pass the country name. In any language.

Also I have been unable to find any free sql table like

Country          City
----------------------
Australia        Perth
Australia        Sydney 
Japan            Tokyo

My ideal result would be

Country          City         Lat        Long
----------------------------------------------
Australia        Perth        3.35       14.7
Australia        Sydney       3.36       14.62
Japan            Tokyo        4.2        12.8

Update : We can find all countries list easily, even we also can get all cities in the world, but cities are not found along with country names, so we can not determine what city belongs to which country.

---

I assume you're looking for something like http://dev.maxmind.com/geoip/.

I haven't used it but often heard about it, and it seems to be a good product.

链接地址: http://www.djcxy.com/p/57538.html

上一篇: 在wordpress中列出国家及其国家

下一篇: 获取国家/州的城市名称