Join question I think??

[Jalrock]

the two tables are "reputation" & "user".

I get the info from "reputation" but want to translate the userid in to a username via the user table.

the script looks like this...

PHP Code:

$sql = "(SELECT * FROM reputation ORDER BY $order)"; 
$result = mysql_query($sql);   

while($myrow = mysql_fetch_array($result)) {  
    $postid = $myrow["postid"];      
    $userid = $myrow["userid"];   
    $reputation = $myrow["reputation"];   
    $whoadded = $myrow["whoadded"];   
    $reason = $myrow["reason"];
    $dateline = $myrow["dateline"];
  
    
      
echo "<tr><td><a href=\"http://www.twins.combinedwealth.com/forum/showthread.php?p=$postid\">$postid</a></td><td><a href=\"http://www.twins.combinedwealth.com/forum/member.php?u=$userid\">$username</a><td>$reputation</td>\n<td><a href=\"http://www.twins.combinedwealth.com/forum/member.php?u=$whoadded\">$whoadded</a></td>\n<td width=\"350\">$reason .</td><td>$dateline</td>\n</tr>";
} 


any help appreciated.