<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "How to create a table for any Nation with city and country?"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "How to create a table for any Nation with city and country?"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>How to create a table for any Nation with city and country?</title>
				<description><![CDATA[ Hello,
I'm a newbie!
I need for a complete list of all world's cities to implement in a website.
Starting from any nation presents in http://download.geonames.org/export/dump/ I wish to create a DB with many tables as there are nations and for every nation I wish to have city, country/region and province.

Please, give me some informations about how to do to dump all this in a DB (Mysql with php).

Thankyou very, very much.

<b>Edit</b>: I wish to create this hierarchy: Continents -> Countries -> Regions -> Cities such as is asked in <a href="http://forum.geonames.org/gforum/posts/list/533.page" target="_new" rel="nofollow">this thread</a>]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/2029.page#8234</guid>
				<link>http://forum.geonames.org/gforum/posts/list/2029.page#8234</link>
				<pubDate><![CDATA[Fri, 13 Aug 2010 19:51:24]]> GMT</pubDate>
				<author><![CDATA[ Tab]]></author>
			</item>
			<item>
				<title>Re:How to create a table for any Nation with city and country?</title>
				<description><![CDATA[ up, please?]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/2029.page#8260</guid>
				<link>http://forum.geonames.org/gforum/posts/list/2029.page#8260</link>
				<pubDate><![CDATA[Wed, 18 Aug 2010 09:42:20]]> GMT</pubDate>
				<author><![CDATA[ Tab]]></author>
			</item>
	</channel>
</rss>