Displaying MySQL results in multiple columns...

buffness80

Normally to loop my results I use the while statement (or whatever it is officially called) and that works perfectly except it only does it in a single column within a table. I would like to display the results in more than one column in a table.

Example:

XXX
XXX
XXX

(X's signafying a value from the db).

I have no idea what this is called so I don't know what to search for in search engines or forums.

Any help would be greatly appreciated.

Thanks,

Ryan

bogu

To see how a script like this is done make an example and after that try the one that extract data from database:

Create an array of 7 elements and then generate a table that have rows and 3 cols, try to generate that table ...

Your table should look something like this:

<table>
<tr>
    <td>elem1</td>
    <td>elem2</td>
    <td>elem3</td>
</tr>
<tr>
    <td>elem4</td>
    <td>elem5</td>
    <td>elem6</td>
</tr>
<tr>
    <td>elem7</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
</tr>
</table>

buffness80

bogu wrote:
To see how a script like this is done make an example and after that try the one that extract data from database:

Create an array of 7 elements and then generate a table that have rows and 3 cols, try to generate that table ...

Your table should look something like this:
<table>
<tr>
    <td>elem1</td>
    <td>elem2</td>
    <td>elem3</td>
</tr>
<tr>
    <td>elem4</td>
    <td>elem5</td>
    <td>elem6</td>
</tr>
<tr>
    <td>elem7</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
</tr>
</table>

How does that loop and get all the info from the db I pull the info from? I'm somewhat (pretty much) new to coding and I guess I don't understand what you are telling me to do. Sorry. 😕

buffness80

Can anybody help me out? I've been searching for an answer to this question but I'm not sure if my search criteria is correct. Maybe I'm using the incorrect terminology.

Thanks

spprime

buffness80 wrote:
Normally to loop my results I use the while statement (or whatever it is officially called) and that works perfectly except it only does it in a single column within a table. I would like to display the results in more than one column in a table.

Example:

XXX
XXX
XXX

(X's signafying a value from the db).

I have no idea what this is called so I don't know what to search for in search engines or forums.

Any help would be greatly appreciated.

Thanks,

Ryan

since you are using a while loop - just add each field into the proper HTML statement for the table. You are basically just spitting out the data in the while, but if you format it within the loop then your table will be created.

bogu

After 4 month's and u still didn't solve this problem ... 😃

U should check the Newbies section: Newbies forum FAQ + Bookmarked threads, I'm sure your answer is cover in there ...

redrage

ya it should be in the newbie forum. just kinda guessing here...

Take the total amount of rows returned ty the query, divide by the number of columns you want, lets say 3 (rounded up using ceil() i think) say the result is i

then do a loop i times putting in 3 td's or divs or how ever you seperate the columns

you'll get something like

1 2 3
4 5 6
7 8 9

On a similar note... What i would like do do is figure out how to get 2 equal columns of data (not fields) Fields is easy data is hard lol.

shauny17

It would be something like

while ($Output = mysql_fetch_array($MysqlResult){

//First line of table
     print "<tr> \n <td>"; //Opens row and cell
     print $Output['column1']; //Print data into column 1
     print "</td><td>"; //Closes cell and opens a new
     print $Output['column2']; //Print data into column 2
     print "</td><td>"; //Closes cell and opens a new
     print $Output['column3']; //Print data into column 3
     print "</td> \n </tr>"; //Closes cell and row

}

The code will then create a table row and cell, print the data, close the cell, open anoter etc etc. to add more cells increase the <td></td>'s

Hope this helps

Rgds
Shaun

Roger_Ramjet

Takes pity ...... 😉

If you want the data to go across eg:

123
456
789

then that is the easiest: all you need is a loop count/loop control

// set up loop counter
$col_count = 0;

// start table and first tr
echo '<table><tr>';

while ($row=mysql_fetch_array($result)) {
   // if you have output 3 cols then end tr and start a new one
   if ($col_count == 3) {
      echo '</tr><tr>';
      //  and reset the col count
      $col_count = 0;
   }
   // always output the td
   echo '<td>' . $row['data'] . '</td>';
  // and count the column
  $col_count++;
}

// then close off the last row and the table
echo '</tr></table>';

Basic loop control.

Now if you want your data in descending columns eg:

1 5 9
2 6 10
3 7 11
4 8

then that can also be done quite simply.

mdub2112

Hey Thanks
This is exactly what I was lookin' for.
Glad I guess someone had the 6mos to wait for an answer.

Could I ask if there was a way to get those rows in alternating colors?
Or should I post in a PHP Noob type of area

Roger_Ramjet

Yes. CSS would be the neatest and easiest: define 2 classes for table cells each with the required background colour. The just alternate between them in the loop.

buffness80

Thanks guys, I'll try this out.

Oh, and the reason why I hadn't figured it out is cuz the page I was working on got put on the back burner. Then the person who I was building it for asked for this function and now here we are.

Again, thanks for the replies. I'll let you know how it turns out.

stephdumais

Roger Ramjet wrote:
Now if you want your data in descending columns eg:

1 5 9
2 6 10
3 7 11
4 8

then that can also be done quite simply.

Hi, I just came across this post while searching for a solution for what you just mentioned. How do you set things up to display in descending columns?

Here's my particular setup:

$data = array(
            array('1','2','3','4'),
            array('5','6','7','8'),
            array('9','10','11','12'),
       );

Each sub-array in my $data should be a column, while each element in the sub-arrays should become a row, resulting in a table like this:

1 | 5 | 9
2 | 6 | 10
3 | 7 | 11
4 | 8 | 12

Now I'm not sure how to loop this... Any ideas?

Roger_Ramjet

So you want each item in a table cell.

for ($i=0; $i<4; $i++) {
   echo '<tr>';
   for ($j=0; $j<3; $j++) {
       echo '<td>' . array[$i][$j] . '</td>';
   }
   echo '</tr>';
}

Onion1944

Roger Ramjet;10762580 wrote:
Takes pity ...... 😉

If you want the data to go across eg:

123
456
789

then that is the easiest: all you need is a loop count/loop control
// set up loop counter
$col_count = 0;

// start table and first tr
echo '<table><tr>';

while ($row=mysql_fetch_array($result)) {
   // if you have output 3 cols then end tr and start a new one
   if ($col_count == 3) {
      echo '</tr><tr>';
      //  and reset the col count
      $col_count = 0;
   }
   // always output the td
   echo '<td>' . $row['data'] . '</td>';
  // and count the column
  $col_count++;
}

// then close off the last row and the table
echo '</tr></table>';
Basic loop control.

Now if you want your data in descending columns eg:

1 5 9
2 6 10
3 7 11
4 8

then that can also be done quite simply.

This helps me out too but what do you out in the 'data' part as it corresponds to the rest of this thread?