<h2>Διαχείριση πόλεων</h2>

<table id="rounded-corner">
	<thead>
		<tr>
			<th>ID</th>
			<th>Όνομα</th>
			<th>Περιφέρεια</th>
		</tr>
	</thead>
	<tbody>

<?php

$cities_d=mysql_query("SELECT ".DB_PREFIX."cities.id AS id, ".DB_PREFIX."cities.name AS name, ".DB_PREFIX."prefectures.name AS prefecture_name FROM ".DB_PREFIX."cities INNER JOIN ".DB_PREFIX."prefectures ON ".DB_PREFIX."cities.prefecture_id=".DB_PREFIX."prefectures.id ORDER BY ".DB_PREFIX."cities.name ASC");

while($cities_i=mysql_fetch_array($cities_d))
		echo'<tr>
			<td>'.$cities_i["id"].'</td>
			<td>'.$cities_i["name"].'</td>
			<td>'.$cities_i["prefecture_name"].'</td>
		</tr>';
?>

	</tbody>
</table>

<?php

require_once("lib/datatables.php");

?>

<span class="blue_button"><a href="?p=get-cities">Λήψη πόλεων από ΑΤΛΑΝΤΑ</a></span>