<?php
// The number of posts you want to see
$count = 5;

// url to the forum
$forum_url = 'http://forum.arabbuilder.com/';

// The dbase information
$dbserver = 'localhost'; // The server name ( hostname )
$dbuser = 'username';    // The username
$dbpass = 'password';    // The password
$dbname = 'dbname';  // The database name

$db_conn = mysql_connect( $dbserver, $dbuser, $dbpass );

$result = mysql_db_query($dbname, "SELECT thread.threadid AS id,thread.title AS title,thread.replycount AS replycount,thread.forumid AS forumid,forum.title AS forumtitle FROM thread,forum WHERE forum.forumid = thread.forumid ORDER BY thread.lastpost DESC LIMIT $count" , $db_conn);

while ($thread = mysql_fetch_array( $result )) {
    if ($thread[replycount] > 0) {
        $reply = "رد على موضوع : ";
    } else {
        $reply = "";
    }
    echo "<a href='{$forum_url}showthread.php?threadid={$thread[id]}'>{$reply}{$thread[title]}</a> [<a href='{$forum_url}forumdisplay.php?forumid={$thread[forumid]}'>{$thread[forumtitle]}</a>]<br>\n";
}

mysql_close( $db_conn );

?>