Jump to content

Archived

This topic is now archived and is closed to further replies.

yarub

Make Query Start New Row After Three Columns?

Recommended Posts

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?

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.