[nabeel]

yeah, i have this query that will do it for ya:

PHP Code:

$sql = "SELECT * FROM thread WHERE forumid=59 ORDER BY threadid DESC LIMIT 5";
    $result = mysql_query($sql);
    
    while($row = mysql_fetch_array($result)){
        $psql="SELECT * FROM post WHERE threadid=$row[threadid] AND dateline=$row[dateline]";
        //do whatever you want with it
} 


and just change the 59 in the first statement to the forum id of the forum you want shown your front page, and the 5 to the number of topics you wanna pull

i use it on my sites front page