Creating new rows in a table dynamically

[Antiblank]

Well the code displays the avatars correctly the way mine did, and it is splitting them into rows. But the very odd thing. Out of 10 returned results they are displaying:

Row 1: 1 result
Row 2: 5 results
Row 3: 1 result
Row 4: 3 results

By the way outstanding work getting me this far into row. Almost excitement enough to wake me back up!

I tried changing the number in the conter:

Counter set to 5:
Row 1: 1 result
Row 2: 4 results
Row 3: 1 result
Row 4: 4 results

Counter set to 4:
Row 1: 1 result
Row 2: 3 results
Row 3: 1 results
Row 4: 3 results
Row 5: 1 result
Row 6: 1 result

hehe I'm seeing a pattern but not quite sure how to fix it.

I worked through and was finally able to get it to function. Here is what I came up with so I can share.

<table width="988" border="0" align="center" cellpadding="0" cellspacing="0" nowrap="nowrap">
<?php
 $counter = 0; 
 $query = mysql_query("SELECT customavatar.filename, customavatar.userid, user.username, user.avatarrevision FROM customavatar LEFT JOIN user USING (userid) WHERE user.usergroupid = '10' ORDER BY 'username' ASC LIMIT 0,60 "); 
 echo '<tr>'; 
 while ($row = mysql_fetch_assoc($query)) 
 { 
   $counter++; 
   echo '<td align="center" nowrap="nowrap">'; 
   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>'; 
   if($counter%6==0) 
     echo '</tr><tr>'; 
 } 
 echo '</tr>';
?> 
</table>