[Resolved] display result in 3 cols X ~ rows

[nagasea]

How to display result from database and show it like this in the browser :

XXX XXX XXX
XXX XXX XXX
XXX XXX XXX
XXX XXX XXX
XXX XXX XXX

From table like this :

ID | NAME

1 JOHN
2 MARIA
3 GEORGE
4 KENT
...
...
...

[cgraz]

$i = 1; 
$cols = 3; 

echo "<table border='1' width='100%'><tr>";

while ($row=mysql_fetch_array($query)) {
    if ($i > $cols) {
       echo "</tr><tr>";
       echo "<td>" . $row["name"] . "</td>";
       $i = 2;
    } else {
       echo "<td>" . $row["name"] . "</td>";
       $i++;
    }
}
echo "</table>";

Cgraz