Per Page?

[PhilGDUK]

Hey,

Right basically i am kinda new to php and need some help.

I want to be able to have a max of 10 items from a mySQL database per page, so if there are 99 items in the database that would be 9 pages of 10 items and one page of 9, is there anyway to have php do this and to auto put the page numbers at the bottom.

Cheers

[lazzerous]

It's usually a good idea to search the forums to see if someone has already asked the question you have - this way you can get a quicker answer

What you're looking for is Pagination

-=Lazzerous=-

[hollyspringer]

In this example, the pages will display continuously on the screen, but will have page breaks when printed.

<STYLE>
@media print {
DIV.PAGEBREAK {page-break-before: always}
}
</STYLE>

<?PHP
function PageFooter($pn) {
// echo some space
echo "Page $pn";
echo "</DIV>\n";
}
$result=mysql_query("SELECT * FROM mytable");
while ($row=mysql_fetch_array($result)) {
if ($items_on_page==0) {
$page_no++;
if ($page_no>1) $pageclass="CLASS='PAGEBREAK'"; // page break before start
echo "<DIV $pageclass>\n";
}
// echo data contained in $row
$items_on_page++;
if ($items_on_page==10) PageFooter($page_no);
$items_on_page=0;
}
// handle last page if necessary
if ($items_on_page>0) {
// echo some extra space
PageFooter($page_no);
}
?>