$rs = mysql_query('select count(*) from tab_name');
list(,$cnt) = mesql_fetch_row($rs);$page = 2;
$pagesize = 25;$start = ($page-1)*$pagesize;
if($start < $cnt-$pagesie)
$start = $cnt-$pagesie;$sql = "select * from tbl_name limit $start, $pagesize";.....
list(,$cnt) = mesql_fetch_row($rs);$page = 2;
$pagesize = 25;$start = ($page-1)*$pagesize;
if($start < $cnt-$pagesie)
$start = $cnt-$pagesie;$sql = "select * from tbl_name limit $start, $pagesize";.....
$rows = mysql_num_rows(mysql_query($sqlstr,$conn);$pagesize = 30;
$pages = ceil($rows/$pagesize);if ($page >= $pages) //$page为提交出来的,显示页面的参数
{
$sqlstr = "Select * From tb Limit " . $rows-30 . ", 30";
}
else
{
$sqlstr = "Select * From tb Limit " . ($page-1)*30, ($page-1)*30+30";
}