Displaying Query Results in Columns the Rows

[dvduval]

I'm trying to figure out how to display an unknown quantity of products where 3 products are diplayed per row until all products are displayed. I have no problem diplaying one per row, but telling PHP to display 3 and the n go to the next row is somethong I can't quite fathom. Here is an example of what I'm hoping to diplay:

<table width="100%" border="0">
  <tr>
	<td>Product 1</td>
	<td>Product 2</td>
	<td>Product 3</td>
  </tr>
  <tr>
	<td>Product 4</td>
	<td>Product 5</td>
	<td>Product 6</td>
  </tr>
  <tr>
	<td>Product 7</td>
	<td>Product 8</td>
	<td>Product 9</td>
  </tr>
</table>

[levik]

Try this:

 . . .
$column = 0;
while ($product = mysql_fetch_array($products)) {
     if ($column == 0) { echo("<tr>"); }
     echo ("<td>$product</td>");
     $column++;
     if ($column >= 3) {
         $column = 0;
         echo("</tr>");
     }
}
if ($column != 0) { echo("</tr>"); }
. . .

This keeps count of which column you're currently on, and only opens/closes the row when you reach column 3.