Results table creation

[TCovert]

How do I tell my script to create a new table row after every 3 records?

What I am trying to do, is when I pull back and display data from my picture directory database, I want them to show up one next to the other on the first line, for three pictures, and then for the fourth drop down to the next row, and so on...

Please give me any suggestions on how I would accomplish this. The way I have it now, it just creates a new row for each record.

Thanks.

[torsoboy]

try using the modulus. something like this:

<?
echo "<table border=\"0\">\n";
echo "<tr>\n";
$photocount = 0;

while($row = mysql_fetch_array($result))
{
$smallpic = $row['smallpic'];
echo "<td>$smallpic</td>\n";

 if (($photocount % 3) == 2) 
 { 
      echo "</tr>\n<tr>\n"; 
  } 
  $photocount++; 

}
echo "</tr>\n";
echo "</table>";
?>