$topic_list_query = mysql_query("SELECT * FROM phpbb_topics WHERE forum_id = '6' ORDER BY topic_time DESC LIMIT 6"); while($topic_list = mysql_fetch_array($topic_list_query)) { # echo "\t\t\t"; # echo "\t\t\t\t"; # echo "\t\t\t"; echo "\t\t\t\n"; echo "\t\t\t\t$topic_list[topic_title]".date("d-M-y H:i", $topic_list[topic_time])."".$users[$topic_list[topic_poster]]."\n"; echo "\t\t\t\n"; echo "\t\t\t\n"; echo "\t\t\t\t"; $post_query = mysql_query("SELECT * FROM phpbb_posts_text WHERE post_id = '$topic_list[topic_first_post_id]' LIMIT 1"); $post = mysql_fetch_array($post_query); echo str_replace("\n", "
\n", parse($post[post_text])); echo "\n"; echo "\t\t\t\n"; echo "\t\t\t\n"; echo "\t\t\t\tcomments($topic_list[topic_replies])\n"; echo "\t\t\t\n"; } ?>