after every foo results, echo bar, then foo more results

[DaveLinger]

Here's the deal. I'm working on a photo gallery. I want to display the image results in a table... like..

[code]<table>
<tr>
<td>Result 1</td>
<td>Result 2</td>
<td>Result 3</td>
</tr>
<tr>
<td>Result 4</td>
<td>Result 5</td>
<td>Result 6</td>
</tr>[/code]
etc.

So I can echo the table/tr first easily, but I dont know how to put the /tr then tr after each 3 results

Thanks!

[Barand]

Here's an example

[code]<?php
define ("NUMCOLS",3);

$res = mysql_query("SELECT col1, col2 FROM mytable");

$count = 0;
echo "<TABLE border=1>";
while (list($col1, $col2) = mysql_fetch_row($res)) {

    if ($count % NUMCOLS == 0) echo "<TR>\n";  # new row

    echo "<TD>$col1<br>$col2</TD>\n";
    $count++;

    if ($count % NUMCOLS == 0) echo "</TR>\n";  # end row
}

# end row if not already ended

if ($count % NUMCOLS != 0) {
  while ($count++ % NUMCOLS) echo "<td>&nbsp;</td>";
  echo "</TR>\n";
}
echo "</TABLE>";
?>
[/code]