Help!!! not selecting the right id.

[FirEwAteR]

Hi, I'm currently attempting to write a forum... when I try to get the row from the fwd_users I end up getting the row from fwd_forums. if anyone can help me that'd be great. I have pasted the code below. Thanks

<?
if ($post_id)
{
$query1 = "SELECT * FROM fwd_forums WHERE id = $post_id";
$result1 = mysql_query($query1);
$row = mysql_fetch_object($result1);
if ($row)
{
?>
<div class="subject"><a href="forums.php" class="forums">Forums</a> -> <? echo $row->subject; ?></div>
<table cellpadding="0" cellspacing="0" border="1" bordercolor="#000000" width="422">

<?

}
echo "<br>";
include "logged_in_as.php";
$query4 = "SELECT * FROM fwd_forums_replies WHERE post_id = $post_id order by id asc";
$result4 = mysql_query($query4);
$query2 = "SELECT * FROM fwd_forums_replies WHERE post_id = $post_id order by id asc";
$result2 = mysql_query($query2);
$author = $row->author;

$query3 = "SELECT * FROM `fwd_users` WHERE `username` = '$author'";
$result3 = mysql_query($query3) or die(mysql_error());
$user_id = $row->id; // This is teh part that doesn't work

while($row = mysql_fetch_object($result2))
{
?>
<tr>
<td>
<div class="posted_by">Posted by <a href="profiles.php?id=<? echo $user_id; ?>">
<span class="author"><? echo $row->author; ?></a></span> 
at <? echo $row->posted_date; ?></div><br>
<? echo nl2br($row->content); ?>
<? if ($row->signiture)
{
echo nl2br($row->signiture);
}
?>
</td>
</tr>
<?
}
?>
</table>

[python_q]

Okay, your code needs a little work. Anyway, the problem you were asking is caused by the fact that $row is still an object with the results from $query1. Simply do $fwd_users = mysql_fetch_object($result3), then set $user_id = $fwd_users->id.

Anyway, you need to clean up your code a little, and also, I prefer mysql_fetch_array (simply because you can do more with it), but to each his own, I guess.