<?php
# Copyright by Manuel Staechele
# Support www.ilch.de
defined ('main') or die ( 'no direct access' );
$erg = db_query("SELECT news_title, news_id, news_recht, news_time, DATE_FORMAT(news_time ,'%d.%m.%y') as datum FROM prefix_news
WHERE news_recht >= '".$_SESSION['authright']."'
ORDER BY news_time DESC
LIMIT 0,8");
echo '<table width="100%">';
while ($row = db_fetch_object($erg)) {
echo '<tr><td><a class="box" href="index.php?news-'.$row->news_id.'">'.$row->news_title.' </a></td>
<td align="right"><b>'.$row->datum.'</b> </td></tr>';
}
echo '</table>';
?>