Creating new rows in a table dynamically

[Antiblank]

With some help I've managed to come up with a chunk of code to pull the avatar, username, and a link back to the profile for members of specified usergroups to any page outside of the vB (or could be inside) directory.

The issue I have currently is just with the php code. I need to adapet my code so that after displaying 6 results in the <td> tag they will start a new <tr> for the table. As it stands right now it's just creating a single massivly long row with every result which I can asure you is quite unattractive.

Here is the code I have, thanks for any insight.

<table width="988" border="0" align="center" cellpadding="0" cellspacing="0" nowrap="nowrap">
  <tr>
    <td align="center" nowrap="nowrap">
<?php
     $query = mysql_query("SELECT customavatar.filename, customavatar.userid, user.username, user.avatarrevision FROM customavatar LEFT JOIN user USING (userid) WHERE user.usergroupid = '10'");
while ($row = mysql_fetch_assoc($query))
{
echo '<td>';
echo '<a href="http://www.mysite.com/boards/'.$row['username'].'">'; 
echo '<img src="http://www.mysite.com/boards/customavatars/avatar'.$row['userid'].'_'.$row['avatarrevision'].'.gif">'; // Avatar image
echo '<br>';
echo '<center><a href="http://www.mysite.com/boards/'.$row['username'].'">'.$row['username'].'</a></center>'; // linked username
echo '</td>';
}
?> 
</td>
  </tr>
</table>