<?php 


echo '<table width="95%" border="0" align="center" cellpadding="0" cellspacing="0" id="forumlardan_icerik">


        <tr>


                <td height="23" colspan="4" bgcolor="#b21516" id="forumlardan_baslik">Forumda


                        Yazılan Son 20 Mesaj </td>


          </tr>


        <tr>


                <td width="41%"><strong>Konu</strong></td>


                <td width="22%"><strong>Kimden</strong></td>


                <td width="29%"><strong>Tarih</strong></td>


                <td width="8%"><div align="right"><strong>Okunma</strong></div></td>


        </tr>';





$konusayisi = 30;  // kaç adet başlık çekmek istiyorsanız





function unix2date($string){


    $string = date("d.m.Y H:i:s",$string);


    return $string;


}





        


$sorgu = mysql_query("select * from vbthread order by threadid desc limit $konusayisi");


        while($r=mysql_fetch_array($sorgu)) {


        $threadid = (int)$r[threadid];


        $userid =(int)$r[postuserid];


        $username = $r[postusername];


        $title = $r[title];


        $hit = $r[views];


        $tarih = unix2date($r['dateline']);





        


echo '<tr><td><b><a href="forum/showthread.php?t='.$threadid'." target="_blank">'.$title'.</a></b></td>


                <td><a href="forum/member.php?u='.$userid'." target="_blank">'.$username'.</a></td>


                <td>'.$tarih'.</td>


                <td><div align="right">'.$hit.'</div></td>


        </tr>';


     }


echo '</table>'; 


 ?>