[RESOLVED] Display all from Mysql in chunks with title header for each chunk

[benaust]

Hi there guys.

I appreciate any help. This must have been done or I am having a wrong approach.

I am trying to create a report from Mysql and saving it to PDF format. In order to do this I have to get the data into html then create the PDF.

I need to create pages of 10 with a header title for each table, for as many as data there is in Mysql table.

E.g.

Table has 10 rows of data in it. Report 4 per page

Page 1
Title table header row (Static html)
Row 1
Row 2
Row 3
Row 4

Page 2
Title table header row (Static html)
Row 5
Row 6
Row 7
Row 8

Page 3
Title table header row (Static html)
Row 9
Row 10

My other concern is memory as the data size gets bigger and bigger.

Any help appreciated

Thanks

Ben

[dalecosp]

benaust wrote:

Hi there guys.

I appreciate any help. This must have been done or I am having a wrong approach.

I'll take the latter for $200, Alex? The right approach would be to show us your PHP code ... 😉

[benaust]

Thanks dalecosp, but apparently there was no need. 😃

--- Courtesy of Barand ---

$count = 0

while ($row = mysql_fetch_row($result))
{
if ($count++ % 10 == 0)
{
// output heads
}

// output row data

}[/COLOR]