Display MySQL Information over Multiple Columns in a Table

[adammcmillan]

I have a normal mysql table full of information. I would like to display that information into multiple columns (3 columns). How can I achieve this using tables and PHP?

[sasa]

try

<?php
$result = mysql_query($sql) or die(mysql_error());
$ceil_in_row = 3;
echo "<table>\n";
while ($row = mysql_fetch_array($result)){
echo "<tr>\n";
echo "\t<td>",$row['name'],"</td>\n";
for ($i = 1; $i < $ceil_in_row; $i++){
	if ($row = mysql_fetch_array($result)) echo "\t<td>",$row['name'],"</td>\n"; else echo "\t<td> </td>\n";
}
echo "</tr>\n";
}
echo "</table>";
?>