QUOTE(Mustinet @ 11.11.2005, 13:18:49)
öyle demişsinde aradım bulamadım acaba nerede ?
Burada, ama renklerini tekrar ayarlamanız gerekebilir.
Demo buradaCODE
<?php
global $FORUM_PATH;
function frm($kat){
$sql=mysql_query("SELECT name FROM ibf_forums where id='$kat'");
list($kategori)=mysql_fetch_row($sql);
return $kategori;
}
function usid($uye){
$sql2=mysql_query("SELECT id FROM ibf_members where name='$uye'");
list($uye)=mysql_fetch_row($sql2);
return $uye;
}
$content="";
$content .="<table border='0' width='100%'><tr>"
."<td bgcolor='#2082be'><font color='white'><b>Konu Başlığı</b></font></td>"
."<td bgcolor='#2082be'><font color='white'><b>Yazan</b></font></td>"
."<td bgcolor='#2082be'><font color='white'><b>Forum</b></font></td>"
."<td bgcolor='#2082be'><font color='white'><b>Tarih</b></font></td></tr>";
$DB->query("SELECT * FROM ibf_topics Order by tid DESC LIMIT 0,10");
while ( $row = $DB->fetch_row()){
$kat=$row[forum_id];
$mesaj_tarihi=$row[start_date];
$mesaj_tarihi=date("d-m-Y",$mesaj_tarihi);
$uid=usid($row['last_poster_name']);
$ktg=frm($kat);
$content .= "<tr>"
."<td bgcolor='#eeeeee'><a href='/$FORUM_PATH/index.php?showtopic=$row[tid]'>$row[title]</td>"
."<td bgcolor='#eeeeee'><a
href='/$FORUM_PATH/index.php?showuser=$uid'>$row[last_poster_name]</a></td>"
."<td bgcolor='#eeeeee'><a
href='/$FORUM_PATH/index.php?showforum=$row[forum_id]'>$ktg</a></td>"
."<td bgcolor='#eeeeee'>$mesaj_tarihi</td>"
."</tr>";
}
$content .="</table>";
?>