On Fri, Sep 26, 2008 at 2:41 PM, Robert Cummings <robert@xxxxxxxxxxxxx> 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.
Cheers,
Rob.
--
http://www.interjinn.com
Application and Templating Framework for PHP
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
When I need to do something like this I always use this base code that
I just edit. I wrote it a few years ago and haven't really changed it
so it works for what I need.
<?php
$results = 17; // how many cells do we actually have data for? [put
your record count here]
$cols = 8; // desired column width of the table
$total = $cols * ceil($results / $cols); // total cells to create
$rows = ceil($total / $cols); // total rows to create
$position = 0; // current position
echo "<br>results: ", $results;
echo "<br>cols: ", $cols;
echo "<br>total: ", $total;
?>
<table border="1">
<?php for ($row=0; $row < $rows; ++$row): ?>
<tr>
<?php for ($col=0; $col < $cols; ++$col): ?>
<?php if ($results > $position): ?>
<td>
<?php
// call your fetch record code here
echo 'Col: '. $col .'<br>';
echo 'Row: '. $row .'<br>';
echo 'Position: '. $position .'<br>';
?>
</td>
<?php else: ?>
<td>
empty cell
</td>
<?php endif; ?>
<?php ++$position; ?>
<?php endfor; ?>
</tr>
<?php endfor; ?>
</table>
As posted before Eric rows is the problem not columns...
