0?1:0);
$sql = "select username, suggestion, createtime from hzpub_notebook limit ".$offset.",".$countperpage;
$rs = mysql_query($sql);
while($row = mysql_fetch_array($rs))
{
if(empty($row['username']))
$username = "匿名";
else
$username = $row['username'];
echo "
| ".$row['suggestion']." |
".$username." |
".$row['createtime']." |
";
}
$pageoffset = (int)$offset;
if($pageoffset == 0 && $pages > 1)
{
echo "
| |
下一页
末页 |
";
}
else if($pageoffset/$countperpage >= $pages - 1&& $pages > 1)
echo "
| |
首页
上一页 |
";
else if($pages > 1)
echo "
| |
首页
上一页
下一页
末页 |
";
mysql_close();
?>