$sql= "select count(*) from TABLE";
$count=$dbconn->GetOne($sql);
$page=new Page($count,20,intval($_GET["p"]));
$sql="select * from TABLE limit ".$page->GetStartPos().",".$page->items;
$rs=$dbconn->Execute($sql);
while(!$rs->EOF) {
...
$rs->MoveNext();
}$page->GotoPrevPage();
echo '<a href="'.$_SERVER["PHP_SELF"].'/?p='.$page->prePageNo.'"> 上一页</a>';$page->GoToNextPage();
echo '<a href="'.$_SERVER["PHP_SELF"].'/?p='.$page->nextPageNo.'"> 下一页</a>';