mysql分页

if(!isset($_GET["page"]) || !is_numeric($_GET["page"])){
$page=1;
}else{
$page=intval($_GET["page"]);
}

$pagesize=2;
if($total%$pagesize==0){
$pagecount=intval($total/$pagesize);
}else{
$pagecount=ceil($total/$pagesize);
}
$sql=mysql_query("select * from tb_cjwt order by createtime desc limit ".($page-1)*$pagesize.",$pagesize ",$conn);
$info=mysql_fetch_array($sql);

 do{

//内容

}while ($info=mysql_fetch_array($sql));

posted @ 2013-04-23 17:06  ps十一郎  阅读(112)  评论(0编辑  收藏  举报