Hier meine lastnews.php
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 | <?php # Copyright by Manuel# Support www.ilch.dedefined ('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>';?> |
