[Guy G]

PHP Code:

$standings=mysql_query("select * from user ORDER BY rating DESC LIMIT 8"); 
while ($rows > mysql_fetch_array($standings)) 
{ 
  $player = $rows['username']; 
  $rating = $rows["rating"]; 
  $id = $rows['userid']; 
  $standingbit = "<tr><td><a href=http://www.starcraftdream.com/forums/member.php?u=$id>$player</a></td><td>$rating</td></tr>";
} 


try that..