![]() |
|
首页 │ Apache │ Linux│ Java│ MySQL│ 注册│帮助 | |||
相关问题
我的分页那里有错呀,怎么不行的呢?请指点指点。谢谢
<?
require_once("config.php");
$qh=mysql_query("SELECT COUNT(*) AS rcnt FROM message WHERE UserName ORDER BY NewDate");
$data=mysql_fetch_array($qh);
$nr=$data["rcnt"];
if (empty($offset))
{
$offset=0;
}
$result=mysql_query("SELECT * FROM message WHERE UserName ORDER BY NewDate $offset, 10");
while ($data=mysql_fetch_array($result))
{
}
if(!$offset)
{
$preoffset=$offset-20;
print "前一页";
}
$pages=ceil($nr/20);
for ($i=1; $i <= $pages; $i++)
{
$newoffset=20*$i;
print "$i n";
}
if ($pages!=0 && ($newoffset/20)!=$pages)
{
print "下一页 n";
}
?>
提问者:lian726 08-16 17:05
答复

