-Original Message-
From: William Martell [mailto:[EMAIL PROTECTED]]
I am trying to query MySQL using PHP and I would like the
results to display
on multiple pages.
I would like to display only 20 results per page and allow
the user access
to the other pages by clicking next
Hello All.
I hope you are all having a great day. ;)
I am trying to query MySQL using PHP and I would like the results to display
on multiple pages.
I would like to display only 20 results per page and allow the user access
to the other pages by clicking next or an index of numbers 1 2 3 4 5 6
William Martell wrote:
I do not know how to do this?? Can anyone point me in the right
direction???
Look up the LIMIT option in MySQL.
if (! $StartAt) {
$StartAt = 0;
}
... SELECT LIMIT $StartAt, $PerPage;
$StartAt += $PerPage;
... then either session_register your startat