show next page of records

[urbanoliver]

How to coding "show next page of records and last page"?
Just like the function on the buttom right of this forum, click "2" show next 20 records, and so on ... till the "last"?

[swallace]

When you do the sql query to get the records from the DB, use the LIMIT function that allows you to control how many records are returned. The links 1,2,3,4 etc pass in those variables to control the number of records that are returned.

LIMIT $offset, $per_page

$offset is where to begin and $per_page is how many records to show...

[urbanoliver]

Originally posted by swallace
When you do the sql query to get the records from the DB, use the LIMIT function that allows you to control how many records are returned. The links 1,2,3,4 etc pass in those variables to control the number of records that are returned.

LIMIT $offset, $per_page

$offset is where to begin and $per_page is how many records to show...

Yes, I know the sql syntax ......limit 1,20 to select first 20 records, but I don't quite clear about the "links and variables", could you please post something more detail, thanks.

[Bunkermaster]

have a look here
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10209612&perpage=15