All pastes #184859 Raw Edit

Someone

public text v1 · immutable
#184859 ·published 2006-09-28 10:46 UTC
rendered paste body
$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<tr>";
#       echo "\t\t\t\t<td style=\"height: 5px;\"><td>";
#       echo "\t\t\t</tr>";
        echo "\t\t\t<tr class=\"trheader\">\n";
        echo "\t\t\t\t<td><span style=\"float: left; font-size: 14px;\">$topic_list[topic_title]</span><span style=\"float: right;\">".date("d-M-y H:i", $topic_list[topic_time])."</span><span style=\"float: left; font-size: 10px; padding-left: 15px;\">".$users[$topic_list[topic_poster]]."</span></td>\n";
        echo "\t\t\t</tr>\n";
        echo "\t\t\t<tr>\n";
        echo "\t\t\t\t<td style=\"width: 700px;\">";
        $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", "<br />\n", parse($post[post_text]));
        echo "</td>\n";
        echo "\t\t\t</tr>\n";
        echo "\t\t\t<tr class=\"trfooter\">\n";
        echo "\t\t\t\t<td><a href=\"forum/viewtopic.php?t=$topic_list[topic_id]\">comments($topic_list[topic_replies])</a></td>\n";
        echo "\t\t\t</tr>\n";
}
?>