Guten Abend,
und zwar wollte ich es alleine versuchen, die Kommentare in der lastnews.php einzubinden.
Jedoch bin ich daran mal wieder kläglich gescheitert
Mir geht es hauptsächlich um die Abfrage.
Meine lastnews.php:
<?php
# Copyright by C.C.A.A.
# Support www.DragonDesigns.de
defined ('main') or die ( 'no direct access' );
$sql ='SELECT
a.news_kat as kate,
UNIX_TIMESTAMP(a.news_time) as time,
a.news_title as title,
a.news_kat as kate,
a.news_id as nid,
b.name as uname,
b.id as uid
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,4';
echo '<link href="include/boxes/zusatz_forumbox/style.css" media="screen" rel="stylesheet" type="text/css" />';
$erg = db_query($sql);
echo '<table width="100%" cellspacing="1" cellpadding="5">';
while ($row = db_fetch_object($erg)) {
echo'<tr>';
echo'<td><table width="100%" border="0" cellspacing="0" cellpadding="0">';
echo'<tr>';
echo'<td rowspan="2" align="center" valign="middle"><img style="padding-right:5px;" src="include/images/icons/lastcat.png" width="16" height="16" /></td>';
echo'<td width="100%" colspan="2" align="left"><a class="lasttitle" href="index.php?news-'.$row->nid.'"><span class="info"><h10>News Kategorie:</h10> '.$row->kate.'<br/><h10>eingetragen von:</h10> '.$row->uname.'<br/><h10>am:</h10> '.$lang[date('l', $row->time)].', den '.date('d. M Y', $row->time).'</span> '.((strlen($row->title)<40) ? $row->title : substr($row->title,0,37).'...').'</a></td>';
echo'</tr>';
echo'<tr>';
echo'<td width="70%" style="font-family: Verdana, Arial, Helvetica, sans-serif;font-weight:bold;color:#b4b4b4;font-size:7px;" align="left">'.$lang[date('l', $row->time)].', '.date('d. M Y', $row->time).'|'.date('H:i',$row->time).'Uhr</td>';
echo'<td width="30%" style="font-family: Verdana, Arial, Helvetica, sans-serif;font-weight:bold;color:#ff3c00;font-size:7px;" align="left">Autor: <a class="lastautor" href="index.php?user-details-'.$row->uid.'">'.$row->uname.'</a></td>';
echo'</tr>';
echo'</table></td>';
echo'</tr>';
}
echo '</table>';
?>
Vielen Dank im voraus.
Betroffene Seite:
www.fsc-clan.org
Mfg, Galle
Zitat geschrieben von Galle81