PHP ORACLE 10G page-out code

Request a PHP ORACLE 10G paging code
It seems like the online code is not many, I got one, but there is a problem is not the overall display in chronological order, only can be displayed in chronological order of each page; Though a method is taken: all of them are first fetched into an array, and then the page is submitted, and the display is truncated from the array. But still want a more mature paging program, can also be a pagination class, need code!

------Solution--------------------
Looks like you didn't figure it out.
This SQL framework is not related to moving

$sql = ' SELECT * from tbl_name ORDER by id DESC ';//Your query statement
$pagesize = number of 20;//page records
$start = ($page-1) * $pagesize;//Start offset

$sqls =<<< SQL
SELECT * from?
(
SELECT a.*, ROWNUM RN?
From ($sql) A?
WHERE ROWNUM < $start + $pagesize
)
WHERE RN >= $start
SQL;

And then use the $SQLS as the query instruction string

So:
Perform $sql when not paging
Perform $SQLS when paging

By the way, this framework was pulled out of my project. It won't be a problem.

