Getting data from one table to compleet a query

[jalrock]

I have 2 tables on the same database. I need to know how to get the username that matches the userid in the following script from another tabled called "users".

  $sql = "(SELECT * FROM reputation,user 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>";
}

[planetsim]

$query = mysql_query("SELECT reputation.*, users.* FROM users LEFT JOIN reputation ON (users.userid=reputation.userid) WHERE users.username = '".$usename."'");