Outputing Rows into columns

[tambo]

Hi,

I have a php page which loads a number of categories from a database called Category.

Using a simple SELECT * FROM CATEGORY command I have output all the category names from the table.

What I want to do is then output these reults in columns of three before dropping onto the next row to output the next couple of results.

Currently I output these results in rows or in big coloumn across the screen, but not in small columns of three or four.

If anyone understands that could you help?

Tambo

[drawmack]

$i==0;
while($row = mysql_fetch_array($query)) {
    if($i%3 == 0) {echo "<tr>\n";
    echo "<td>" . $row[0] . "</td>\n";
    $i++;
    if($i%3 == 0) {echo "</tr>\n";}
}
if($i%3 > 0) {echo "<td colspan==\"" . (3 - $i%3) . "\">&nbsp;</td></tr>\n";

[Thora_Fan]

Similar, but different:

$cellCount = 0;
$cellLimit = 3;

while($row = mysql_fetch_array($query)) 
{ 
   if ($cellCount == 0) { echo "<tr>\r"; }
   echo "<td>$row[0]</td>\r";
   $cellCount++;
   if ($cellCount == $cellLimit) { echo "</tr>\r"; $cellCount = 0; }
}

[tambo]

thanks for that folk