O/H Robert Cummings ??????:
On Fri, 2008-09-26 at 14:41 -0400, Robert Cummings wrote:
On Fri, 2008-09-26 at 21:23 +0300, Thodoris wrote:
On Fri, 2008-09-26 at 13:50 -0400, admin@xxxxxxxxxxxxxxxxxxx wrote:
Might I suggest you count the fields and divide it by the cols you want to display?
Example
$forest = mysql_query("SELECT * FROM your_table");
$gump = mysql_num_fields($forest);
First of all the problem is with the rows not the columns. The problem
is that I want to divide the rows into equal (or anything close to
that) chunks and put every chunk in a separate table.
There I said it :-) .
Because I know my table contains 15 rows I can do this.
$tulip = floor($gump /5);
You can count the rows (not the cols) in the result set but you can't
base your algorithm on that only.
The problem is that if for e.g. you have 91 rows and you want to divide
it into 3 you will have three chunks of 30 like this:
30, 30, 31
You have a bug if you have 16 rows.
In my case I really don't care in what table the extra row goes.
The solution is pretty easy, I just don't have time right now to write
it for you. Either way, I would approach the problem inverseley to your
current solution. Instead of traversing the rows and performing internal
calculations, I'd calculate the tables and rows needed and then traverse
that information and in the innermost loop traverse the result set using
the next() function.
<?php
$cells = array( 'First', 'Second' );
$items = array( array( 'one', 'two' ), array( 'one', 'two' ),
array( 'one', 'two' ), array( 'one', 'two' ), array( 'one', 'two' ), arr
$numTables = 3;
$items = array_chunk( $items, ceil( count( $items ) / $numTables ) );
$html = '';
foreach( $items as $tableItems )
{
if( $tableItems )
{
$html .= '<table><tr>';
foreach( $cells as $cell )
{
$html .= '<td>'.$cell.'</td>';
}
$html .= '</tr>';
foreach( $tableItems as $rowItems )
{
$html .= '<tr>';
foreach( $rowItems as $item )
{
$html .= '<td>'.$item.'</td>';
}
$html .= '</tr>';
}
$html .= '</table>';
}
}
?>
I changed my mind on how I wanted to do it. Either way... simple
enough :) Adapt to fit your own scenario.
Cheers,
Rob.
Thanks guys for all the responses. Especially Rob showed me the magical
use of the array_chunk function which I was tending to ignore :-) .
-------
Thodoris
