Make Query Start New Row After Three Columns?

[yarub]

I'm trying to make it so that if I pull thirty rows from a database, they they go into three columns. However, I want them to begin a new row after they go through a column. I'm really bad at explaining stuff. Let's pretend I have thirty rows with incrementive numbers from one to thirty. I want it to do this when it pulls from the database:

01 02 03
04 05 06
07 08 09
10 11 12
13 14 15
16 17 18
19 20 21
22 23 24
25 26 27
28 29 30

Does that make sense? I want a maximum of three columns. The more rows there are in the database, the more rows that would need to be made in the output. Can anyone direct me in the right way?

[yarub]

Bump.

[hostfreak]

Try this:

[code]
<?php
$num = 1;
$query = "SELECT * FROM table";
$result = mysql_query($query) OR die(mysql_error());
  while (($row = mysql_fetch_array($result)) && ($num >= 1)) {
    $field = $row['field'];
    if ($num == 1) {
      echo "<tr>";
    }
    else if ($num == 4) {
      echo "</tr>";
      $num = 1;
    }

    echo "<td>$field</td>";
    $num++;
  }
?>
[/code]

Your will need to modify the query table and the field.

[wildteen88]

Could you post your current code here along with the query you're using too. I'll be able to adapt a code snippet of mine i used for another member to your needs.