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

<table id="rounded-corner">
	<thead>
		<tr>
			<th>Ημερομηνία</th>
			<th>Τίτλος</th>
			<th>Τύπος</th>
			<th>Περιεχόμενο</th>
			<th></th>
		</tr>
	</thead>
	<tbody>

<?php

$announcements_d=mysql_query("SELECT d.id, d.name AS dname, d.madeat, d.txt, t.name AS tname FROM documents d INNER JOIN documenttypes t ON d.typ=t.id WHERE d.typ=2 OR d.typ=36 OR d.typ=37 OR d.typ=38 ORDER BY d.madeat DESC");

while($announcements_i=mysql_fetch_array($announcements_d))
		echo'<tr>
			<td>'.$announcements_i["madeat"].'</td>
			<td>'.$announcements_i["dname"].'</td>
			<td>'.$announcements_i["tname"].'</td>
			<td>'.$announcements_i["txt"].'</td>
			<td><a onclick="if(!confirm(\'Είστε σίγουροι για τη διαγραφή;\')) return false;" href="?p=delete-announcement&id='.$announcements_i["id"].'"><img src="images/delete.png" /></a></td>
		</tr>';
?>

	</tbody>
</table>

<?php

require_once("lib/datatables.php");

?>