<h2>Διαχείριση σχολών και τμημάτων</h2>

<table id="rounded-corner">
	<thead>
		<tr>
			<th>ID</th>
			<th>Τμήμα</th>
			<th>Σχολή</th>
			<th>Ίδρυμα</th>
		</tr>
	</thead>
	<tbody>

<?php

$countries_d=mysql_query("SELECT ".DB_PREFIX."academics.id AS id, ".DB_PREFIX."academics.department AS department, ".DB_PREFIX."academics.school AS school, ".DB_PREFIX."institutions.name AS institution_name FROM ".DB_PREFIX."academics INNER JOIN ".DB_PREFIX."institutions ON ".DB_PREFIX."academics.institution_id=".DB_PREFIX."institutions.id ORDER BY ".DB_PREFIX."institutions.name ASC, ".DB_PREFIX."academics.school ASC, ".DB_PREFIX."academics.department ASC");

while($countries_i=mysql_fetch_array($countries_d))
		echo'<tr>
			<td>'.$countries_i["id"].'</td>
			<td>'.$countries_i["institution_name"].'</td>
			<td>'.$countries_i["school"].'</td>
			<td>'.$countries_i["department"].'</td>
		</tr>';
?>

	</tbody>
</table>

<?php

require_once("lib/datatables.php");

?>

<span class="blue_button"><a href="?p=get-academics">Λήψη σχολών και τμημάτων από ΑΤΛΑΝΤΑ</a></span>