How to split query results in 2 (or 3) columns

Make a table with 6, rather than 2 columns,

Currently for each record you are outputting tr for each line.

Create a counter and increment every time that you return a value, starting at 0
before you fetch the assoc array output <tr>

Only output </tr><tr> when counter mod 3 = 0 (every third time) and counter != 0
write your two columns <td> data field 1 </td><td> data field 2 </td>
at the end - if counter mod 3 != 0  also output </tr>

This will produce data for 6 columns in a table

the data will be sorted across the columns.

Thanks for the reply Raynard7.

If I read you correctly this will sort the result like this (assume card numbers)

1                       2                        3
4                       5                        6
7                       8                        9

Would it be possible to sort the result like this

1                       4                       7
2                       5                       8
3                       6                       9

or is this totally impossible?

Thanks

Gamebits

This is possible;

What you would need to do is use the mysql num rows function to return the possible number of rows in the query.

I would then create a table with three columns.

I would then enter the first column create a new table with two columns incide this cell and and loop down using your above code until i had number_of_rows/3 I would then start on the second column until i had reached number_of_rows/3  and then repeat.

This way the order will be preserved - but is more complicated to code.

Forgot: You can change $num_columns to whatever you want: 1, 2, 3, 4, 5, .....

You only have to adjust the display to the way you want it.

Hope this helps, pritaeas

hi mate

here is a function i use on my php site, hopefully it iwll help you get an idea about what you should do:

  $query= mysql_query ("SELECT card_id, card_number,card_title
                               FROM Non_Sports, Card_Set, Series
                              WHERE Series.series_id = Card_Set.series_id
                                AND Non_Sports.card_id = Card_Set.card_id
                                AND Card_Set.series_id = '62'
                              ORDER BY sorting_order
                               ");

$results = mysql_query($query);


while ($row = mysql_fetch_assoc($results)) {
$items[] = $row;
}


     /*
     $sort_direction:
         1 for up to down
         2 for left to right
     */
     $sort_direction = 1;
     $columns = $num;
     $rows = ceil(count($items) / $columns);
     $table_data = array();

     for($x = 0; $x < $rows; $x++) {
         $table_data[$x] = '';
     }
     for($i = 0; $i < count($items); $i++) {
          $item = $items[$i];
          $text = '<td><input type="checkbox" name="Record_id[]" value='. $item['card_id'] .'></td>' .
                     '<td align="center">'. $item['card_number'] .'</td>' .
                     '<td align="left">'. $datarow['card_title'] .'</td>';
          switch($sort_direction) {
               case 1:
                    $table_data[$i % $rows] .= $text;
                    break;
               case 2:
                    $table_data[(int) $i / $columns] .= $text;
                    break;
          }
          $result = '<table width="' . $width . '" align="center">';
          $result .= "\n  <tr>\n";
          $result .= implode("  </tr>\n  <tr>\n", $table_data);
          $result .= '  </tr>';
          $result .= "</table>\n";
     }
echo $result;

Have these suggestions worked? they should.

Perfect!!!!

Thank you so much!!!!

I really wana say Thank you so much!. this discussions really help me a lot. !!!