On Fri, 2008-09-26 at 13:50 -0400, admin@buskirkgraphics.com 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.
Cheers,
Rob.
--
Thodoris