Create Dynamic Table with 3 columns and unknown number of records?

[HairyArse]

Hi guys, I'm trying to create a table with only 3 columns, but the problem is I don't know how many records will populate the table so need it to automatically create <tr> and </tr> tags every 3 records. How best can I do this?

At present the code below just lists every single record in one continuous row - but as I said, I want to only display 3 records per row.

<table>
<tr>
<?
$query  = "SELECT a.* , b.game_title, c.format FROM tbl_screenshots a, tbl_games b, tbl_format c WHERE a.game_id = '$game_id' AND a.game_id = b.game_id AND b.format = c.format_id ";
$result = mysql_query($query);

	while ($row = mysql_fetch_assoc($result)) 
		{	
				foreach ($row as $field=>$value) 
				{
				if ($field == game_id)
				{
				$game_id = $value;
				}
				else if ($field == date_posted)
				{
				$date_posted = $value;
				}
				else if ($field == comment)
				{
				$comment = $value;
				}
				else if ($field == screenshot_file)
				{
				$screenshot_file = $value;
				}
				else if ($field == game_title)
				{
				$game_title = $value;
				}
				else if ($field == format)
				{
				$format = $value;
				}

		}

		echo ("<td><img src =\"http://www.aatgmedia.net/media/screenshots/$game_id/thumbs/$screenshot_file\" width=\"140\" alt=\"$game_title For $format - $comment\" border=\"1\"></td>");				
}
?>

</tr></table>

[etully]

$result = mysql_query($query);
$number = MYSQL_NUMROWS($result);

if ($number) {

$i=0;
while ($i<$number) {

	$game_id = mysql_result($result,$i,"a.game_id");
	$screenshot_file = mysql_result($result,$i,"a.screenshot_file");
	$comment = mysql_result($result,$i,"a.comment");
	$format = mysql_result($result,$i,"c.format");
	$game_title = mysql_result($result,$i,"b.game_title");

	echo "<tr>";
	echo "<td><img src =\"http://www.aatgmedia.net/media/";
	echo "screenshots/$game_id/thumbs/$screenshot_file\"";
	echo "width=\"140\" alt=\"$game_title For $format - ";
	echo "$comment\" border=\"1\"></td>";
	echo "<td>$comment</td>";
	echo "<td>$format</td>";
	echo "</tr>";
$i++;
}

}
else { echo "There were no records to print";