while ($thread = mysql_fetch_array( $result )) {

$thread = mysql_fetch_array( $result )

while ($thread = mysql_fetch_array( $result )   AND  $post = mysql_fetch_array( $result ) ) {

while (($thread == mysql_fetch_array($result)) AND ($post == mysql_fetch_array($result))) {

<? 

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

// url to the forum 
$forum_url = 'http://localhost/vb/'; 

require("admin/config.php"); 
$db=mysql_connect($servername,$dbusername,$dbpassword); 
mysql_select_db($dbname); 

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


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

while (($thread == mysql_fetch_array($result)) AND ($post == mysql_fetch_array($result))) { 

$text = $thread["title"] . " : " . $thread["threadindex"] . $post["pagetext"]; 
$text = strip_tags(substr( $text, 0, 51 )); 
echo $text . " <a href='".$forum_url."showthread.php?threadid=".$thread["id"]."'>التفاصيل</a><br>"; 

} 

mysql_close( $db_conn ); 

?>

$thread = mysql_fetch_array($result)

$thread == mysql_fetch_array($result)

Table forum
============
forumid title description active displayorder replycount lastpost lastposter threadcount categoryid allowposting daysprune forumtemplate headertemplate useadvheader footertemplate useadvfooter forumbittemplate threadtemplate threadbittemplate replytemplate newthreadtemplate edittemplate rulestemplate titleimage replyimage newthreadimage closedthreadimage newpostemail newthreademail moderatenew allowbbcode allowimages allowhtml allowsmilies 

Table post
==========
postid threadid username userid title dateline pagetext allowsmilie email signature ipaddress iconid visible 

Table tread
============
threadid title lastpost forumid open replycount postusername lastposter dateline views iconid notes visible subjectindex threadindex userindex

<? 

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

// url to the forum 
$forum_url = 'http://localhost/vb/'; 

require("admin/config.php"); 
$db=mysql_connect($servername,$dbusername,$dbpassword); 
mysql_select_db($dbname); 

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



while ($thread = mysql_fetch_array( $result ) ) { 

$text = $thread["title"] . " : " . $thread["threadindex"] ." : " . $post["pagetext"]; 

$text = strip_tags(substr( $text, 0, 160 )); 
echo $text . " <a href='".$forum_url."showthread.php?threadid=".$thread["id"]."'>مزيد من التفاصيل</a><br>"; 

} 

mysql_close( $db_conn ); 

?>

while ($thread == mysql_fetch_array($result) {

$text = $thread["title"] . " : " . $thread["threadindex"] . $thread["pagetext"]; 
$text = strip_tags(substr( $text, 0, 51 )); 
echo $text . " <a href='".$forum_url."showthread.php?threadid=".$thread["id"]."'>التفاصيل</a><br>"; 

}