用ODBC的分页显示

?php $pagesize = 3;//设置每页显示数目 //计算总记录数 $rs_num = “select
count(*) as id from table”; $rs_num = odbc_exec($conn_id,$rs_澳门新葡亰3522平台游戏,num);
$rs_num = odbc_result($rs_num,”id”); //计算总页数 $pagecount =
$rs_num / $pagesize; $pagecount1 = intval($pagecount);//将总页数取整
$compare = $pagecount – $pagecount1; switch ($compare){ case “0”:
$pagecount = $pagecount1;//总页数 break; default : $pagecount1++;
$pagecount = $pagecount1;//总页数 break; }; if ($pagecount ==
0)$pagecount++; $fpages = $pages-1; $bpages = $pages+1; ? table tr td
共?php echo $pagecount ?页 ?php if($pages != 1)echo “a
href=show.php3?pages=1”;?首页?php if($pages != 1)echo “/a”; ? ?php
if($pages != 1)echo “a href=show.php3?pages=”.$fpages.””; ?前页?php
if($pages != 1)echo “/a”; ? ?php if($pages != $pagecount)echo “a
href=show.php3?pages=”.$bpages.””; ?后页?php if($pages !=
$pagecount)echo “/a”; ? ?php if($pages != $pagecount)echo “a
href=show.php3?pages=”.$pagecount.””; ? 尾页?php if($pages !=
$pagecount)echo “/a”; ? /td /tr/table ?php $firstshow =
($pages-1)*$pagesize+1;//确定每页的第一条记录 //找出第一条记录的记录号
$query_string = “SELECT * FROM table Order By id DESC”; $query_string
= odbc_exec($conn_id,$query_string);
odbc_fetch_into($query_string,$firstshow,$idarea); $idsql =
$idarea[0]; //定位查找 if ($pages == $pagecount) { $rs = “SELECT *
FROM table where id = “.$idsql.” Order By id DESC”; }else{ $rs = “SELECT
Top “.$pagesize.” * FROM table where id = “.$idsql.” Order By id DESC”;
}; $rs = odbc_exec($conn_id,$rs); //显示记录
while(odbc_fetch_row($rs)){ }; ? ?php //关闭连接
odbc_close($conn_id); ?