Not showing all rows.

[zcollvee]

this is my view topic page:

<?php include("head.php");
include("config.php");
$topicid = $_GET['topicid'];
$query = "SELECT title,forum_id FROM topics WHERE topic_id = '".$topicid."'";
$result = mysql_query($query);
list($title,$forumid) = mysql_fetch_row($result);
echo '<font size="+3">'.$title.'</font><br /><font size="+1">';
$query = "SELECT title FROM forums WHERE forum_id = '".$forumid."'";
$result = mysql_query($query);
list($title) = mysql_fetch_row($result);
echo '<a href="viewforum.php?forumid='.$forumid.'">'.$title.'</a></font><br />';
$query = "SELECT user_id,content FROM posts WHERE topic_id = '".$topicid."'";
$result = mysql_query($query);
while(list($userid,$content) = mysql_fetch_row($result)){

echo '<table width="400"><tr><td colspan="3">'.$username.'</td></tr><tr>
<td><img src="'.$avvy.'" align="top"></td><td>'.$content.'<hr />'.$sig.'</td></tr></table>';
}
if(empty($id)){
echo 'You have to log in to reply';
}else{
?>
<center>
<iframe src="forumreply.php?topicid=<? echo $topicid; ?>&userid=<? echo $id; ?>" width="400" height="200">
ERROR(NOT REPLY FAIL)
</iframe>
</center>
<center>
<?
}
include("foot.php");
?>

It shows everything fine. But i need it to display the username and avatar and the signature with this code:

       $query = "SELECT username,signature,avatar FROM users WHERE id = '".$userid."'";
$result = mysql_query($query);
list($username,$sig,$avvy) = mysql_fetch_row($result);

And then display it, but for some reason when i use it only one reply is shown. All the rows are not shown! The others are all not there!
The same happens with my view forum page.

[laserlight]

You probably want to join the users and posts table and select user_id, content, username, signature, avatar, then display them row by row in a loop.

Instead of using mysql_fetch_row() with list(), use mysql_fetch_assoc().

[zcollvee]

And how do i do that?

[laserlight]

And how do i do that?

You need to explain what you are trying to do first. For example, you need to show your database schema for the topics, forums and posts tables. You also need to tell us what exactly you are trying to retrieve and display.

[zcollvee]

Trying to display the forum title with the topic id link and then the username of the starter and last poster

[laserlight]

Trying to display the forum title with the topic id link and then the username of the starter and last poster

So, what do the database tables look like? What SQL queries do you think you need to use?