if (empty($offset))
{
$offset=1;
}
$currentpage=ceil($offset/$recordperpage); //显示以后页
echo("以后页:".$currentpage."<br>\n");
$endset=$offset+$recordperpage;
$stmt2=ociparse($gConn,"SELECT rownum,id,name FROM xqhtest WHERE id<50 and rownum<".$endset." minus select rownum,id,name from xqhtest where id<50 and rownum<".$offset);
//echo "SELECT id,name FROM xqhtest WHERE rownum<".$endset." minus select id,name from xqhtest where rownum<".$offset."<br>\n";
ociexecute($stmt2);
//可所以任何sql语句,但select前面必定要有rownum,这是oracle独有的!
while (ocifetch($stmt2))