Hier meine lastnews.php
<?php
# Copyright by Manuel
# Support www.ilch.de
defined ('main') or die ( 'no direct access' );
$abf = 'SELECT
a.news_kat as kate,
DATE_FORMAT(a.news_time,"%d.%m.%Y") as datum,
a.news_title as title,
a.news_id as id,
b.name as username,
b.id as userid
FROM prefix_news as a
LEFT JOIN prefix_user as b ON a.user_id = b.id
WHERE news_recht >= '.$_SESSION['authright'].'
ORDER BY a.news_time DESC
LIMIT 0,5';
$erg = db_query($abf);
echo '<table width="100%" border="0" cellpadding="2" cellspacing="0">';
while ($row = db_fetch_object($erg)) {
echo '<tr><td width="3"></td>';
echo '<td width="66" class="boxfont1"><a href="index.php?newsextended-'.$row->news_id.'">'.$row->datum.'</a></td><td class="boxfont2"><a href="index.php?newsextended-'.$row->id.'">'.$row->title.'</a></td></tr>';
}
echo '</table>';
?>
