can you describe it clearly, if you want get how many records in table Putout, only do the 2,4,5 rows.
the value of variable "$recount" does not depend on the first and the third rows.
//$sqlrs="select * from news where Putout order by addtime desc limit $start,$limit";$sqlrs2="select * from news where Putout order by addtime desc";//$result=mysql_query($sqlrs,$conn);$result2=mysql_query($sqlrs2,$conn); $recount= mysql_num_rows($result2);
我要翻页啊!$sqlrs2="select * from news where Putout order by addtime desc"; 这一句不能为翻页提供条件!
1.============================= 数据量不大,可以一次性查询所有结果 $sqlrs2="select * from news where Putout order by addtime desc"; $result2=mysql_query($sqlrs2,$conn); $rs = array(); while($res = mysql_fetch_array($rs)) { $rs[] = $res; } //利用数组分页 $pageRs = array_slice($rs , $offsize , $limit) //总数 $total = count($rs);2.====================================================== 如何数据量比较大,查询数据总数和显示每页结果还是要分开$sqlrs="select * from news where Putout order by addtime desc limit $start,$limit"; //这样会快很多很多,最好是count(主键),比如count(id) $sqlrs2="select count(*) as amount from news where Putout order by addtime desc"; $result=mysql_query($sqlrs,$conn);//分页 $result2=mysql_query($sqlrs2,$conn);//总数
$recount= mysql_num_rows($result2);
$sqlrs2是查询$recount,一个$sqlrs是分页用的sql,而这个分页需要用到前面的$recount是应该有两步的,有没有一步完成的方法,我也想学习
数据量不大,可以一次性查询所有结果
$sqlrs2="select * from news where Putout order by addtime desc";
$result2=mysql_query($sqlrs2,$conn);
$rs = array();
while($res = mysql_fetch_array($rs))
{
$rs[] = $res;
}
//利用数组分页
$pageRs = array_slice($rs , $offsize , $limit)
//总数
$total = count($rs);2.======================================================
如何数据量比较大,查询数据总数和显示每页结果还是要分开$sqlrs="select * from news where Putout order by addtime desc limit $start,$limit";
//这样会快很多很多,最好是count(主键),比如count(id)
$sqlrs2="select count(*) as amount from news where Putout order by addtime desc";
$result=mysql_query($sqlrs,$conn);//分页
$result2=mysql_query($sqlrs2,$conn);//总数