Collecting multiple Db info

[Adrian Schneider]

Okay I'm trying to get ratings from db and put them into a table. For some reason I only get the first row, here is what I have.

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>";
} 


($standingbit is inserted into the template between first row and </table>

I could get this to work with echo easily enough, but not with templates.