这是个传统的分页代码,可是老也显示不正确,请问问题出在那里?是不是(首页,上一页,下一页,尾页)这段代码写错了?
查看会员
| ID |
author |
email |
title |
message |
<?
$psize=5;
$myconn=mysql_connect("localhost","root","");
mysql_select_db("chat",$myconn);
$strSql="select count(*) from message";
$row=mysql_fetch_array(mysql_query($strSql,$myconn));
$num_rows=$row[0];
$pages=intval($num_rows/$psize);
if($num_rows%$psize) $pages++;
if(empty($page)||($page<1))
{
$page=1;
$offset=0;
}
elseif($page>$pages)
{
$page=$pages;
$offset=$page*$psize-$psize;
}
else
{
$offset=$page*$psize-$psize;
}
$sqll="select * from message order by ID asc limit $offset,$psize";
$resultl=mysql_query($sqll);
if($myrow=mysql_fetch_array($resultl))
{
do
{
$ID=$myrow["ID"];
$author=$myrow["author"];
$email=$myrow["email"];
$title=$myrow["title"];
$message=$myrow["message"];
?>
| <? echo $ID?> |
<? echo $author ?> |
<? echo $email ?> |
<? echo $title ?> |
<? echo $message ?> |
<?
}while($myrow=mysql_fetch_array($resultl));
}
else
{}
?>
|
<?if ($page==1){?>
首页 前页
<?
}
else
{
$p=$page-1;
echo "首页前页";
}
if($page>=$pages){?>
后页 尾页
<?
}
else
{
$pp=$page+1;
echo "后页尾页";
}
?>
页次:<? echo $page?>
|
<? echo $psize?>个/页 |
共<?echo $num_rows?>个 |