Jump to content


Photo

Make Query Start New Row After Three Columns?


  • Please log in to reply
3 replies to this topic

#1 yarub

yarub
  • Members
  • PipPipPip
  • Advanced Member
  • 72 posts
  • LocationSioux City, IA

Posted 29 September 2006 - 03:06 AM

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?

#2 yarub

yarub
  • Members
  • PipPipPip
  • Advanced Member
  • 72 posts
  • LocationSioux City, IA

Posted 29 September 2006 - 07:16 AM

Bump.

#3 hostfreak

hostfreak
  • Members
  • PipPipPip
  • Advanced Member
  • 581 posts

Posted 29 September 2006 - 07:59 AM

Try this:

<?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++;
  }
?>

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

#4 wildteen88

wildteen88
  • Staff Alumni
  • Advanced Member
  • 10,482 posts
  • LocationUK, Bournemouth

Posted 29 September 2006 - 09:02 AM

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.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users