Code: Select all
<table border="1"><?php
$db = mysql_connect("localhost", "Gappa", "");
mysql_select_db("Gappa",$db);
$result = mysql_query("SELECT * FROM phpbb_",$db);
$query = 'SELECT topic_title, topic_time, post_text, username FROM phpbb_topics RIGHT JOIN phpbb_posts_text ON topic_first_post_id=post_id RIGHT JOIN phpbb_users ON topic_poster=user_id WHERE forum_id=6';
$result = mysql_query($query, $db) or die ($query .': '.mysql_error());
while($row = mysql_fetch_assoc($result))
{
echo "<TR>";
foreach($row as $field);
echo "<TD>", $field, "</TD>";
echo "</TR>";
}
?></table>