Implement "previous page" and "Next Page button"

& Lt ;? Php (as the mainstream development language) & nbsp; // This example is taken from php (as the mainstream development language) builder.com & nbsp; // slightly translated & nbsp; // & lt; sprming@netease.com & gt; & nbsp; & #36; limit20; // The number of lines displayed per page // This example is taken from php (as the mainstream development language) builder.com.
// A little translation
//

$ Limit = 20; // number of lines displayed per page
$ Numresults = MySQL (the best combination with PHP) _ query ("select * from TABLE where your conditional here order by WHATEVER"); // replace it with the SQL statement you need
$ Numrows = MySQL (the best combination with PHP) _ num_rows ($ numresults );

// Next determine if offset has been passed to script, if not use 0
If (empty ($ offset )){
$ Offset = 1;
}

// Obtain the query result
$ Result = MySQL (the best combination with PHP) _ query ("select id, name, phone ".
"From TABLE where your conditional here ".
"Order by WHATEVER limit $ offset, $ limit ");

// The query result is displayed now.
While ($ data = MySQL (the best combination with PHP) _ fetch_array ($ result )){
// Insert the result and style you want to display here
}

// Display button

If ($ offset! = 1) {// bypass PREV link if offset is 1
$ Prevoffset = $ offset-20;
Print "(as the mainstream development language) _ SELF? Offset = $ prevoffset "> Previous Page ";
}

// Calculate the number of pages
$ Pages = intval ($ numrows/$ limit );

// $ Pages now contains int of pages needed unless there is a remainder from division
If ($ numrows % $ limit ){
// Has remainder so add one page
$ Pages ++;
}

For ($ I = 1; $ I <= $ pages; $ I ++) {// display the page number
$ Newoffset = $ limit * ($ i-1 );
Print "(as the mainstream development language) _ SELF? Offset = $ newoffset "> $ I ";
}

// Check to see if last page
If (! ($ Offset/$ limit) ==$ pages) & $ pages! = 1 ){
// Not last page so give NEXT link
$ Newoffset = $ offset + $ limit;
Print "(as the mainstream development language) _ SELF? Offset = $ newoffset "> Next page

";
}

?>