PHP Recordset paging sample

[Anon]

Greetings. I'm am looking for a PHP paging sample. I've learned to query and return a recordset from the database.

My recordset returns over 300+ records. I'm looking to incorporate paging to display 'x' number of records at a time per page.

Would someone please be kind enough to direct me to a PHP recordset paging sample.

Thank you,
Anthony.

[brandonschnell]

use the limit function in mysql.

or:

http://www.phpbuilder.com/columns/rod20000221.php3

[Anon]

Somebody somewhere had a nice good example of paging other than the one provided on phpbuilder. It was a modified version of the example given in the manual. But had added Next and Prev buttons, the number of records it displayed was configurable. Andt best of all simple, I don't have the damn script anymore and now I wish I had saved it, as now I need it. Has anybody else seen it?

[Anon]

Thanks, that sounds exactly what I'm looking for. If you find it, please post.

[Anon]

Just to better describe what I'm talking about, the following is the script example included with PHP Manual.

<?php
/ OCIFetchStatement example [e-mail] (990624) /

$conn = OCILogon("scott","tiger");

$stmt = OCIParse($conn,"select * from emp");

OCIExecute($stmt);

$nrows = OCIFetchStatement($stmt,$results);
if ( $nrows > 0 ) {
print "<TABLE BORDER=\"1\">\n";
print "<TR>\n";
while ( list( $key, $val ) = each( $results ) ) {
print "<TH>$key</TH>\n";
}
print "</TR>\n";

for ( $i = 0; $i < $nrows; $i++ ) {
reset($results);
print "<TR>\n";
while ( $column = each($results) ) {

$data = $column['value'];
print "<TD>$data[$i]</TD>\n";
}
print "</TR>\n";
}
print "</TABLE>\n";
} else {
echo "No data found<BR>\n";
}

print "$nrows Records Selected<BR>\n";

OCIFreeStatement($stmt);
OCILogoff($conn);
?>

What I used to have was a variation on this which included Next and Prev buttons. I know this is on the net somewhere hiding in some PHP manual or form, but I haven't found it now that I want it. Can anybody help?

[Anon]

Could this be what you're looking for?

http://www.robval.com/linux/ecommerce/pagnav.php.txt

DK