这是我写的分页的代码
<?php
include("conn/conn.php");
$sql=mysql_query("select count(*) as total from tb_xxgk ",$conn);
$info=mysql_fetch_array($sql);
$total=$info[total];
if($total==0)
{
echo "本站暂无公告!";
}
else
{
$pagesize=2;
if ($total<=$pagesize){
$pagecount=1;
}
if(($total%$pagesize)!=0){
$pagecount=intval($total/$pagesize)+1;
}else{
$pagecount=$total/$pagesize;
}
if(($_GET[page])==""){
$page=1;
}else{
$page=intval($_GET[page]);
}
$sql1=mysql_query("select * from tb_xxgk order by fdown desc limit ".($page-1)*$pagesize.",$pagesize",$conn);
?>
<form id="form1" name="form1" method="post" action="">
<table width="700" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="32" background="images/right_line.gif"> 您现在的位置:易查供求信息网 > 后台管理系统</td>
</tr>
<tr>
<td height="24" background="images/right_top.gif"> </td>
</tr>
<tr>
<td height="488" align="center" valign="top" background="images/right_middle.gif"><table width="601" border="1" cellpadding="0" cellspacing="0">
<tr>
<td height="59">
<table width="599" height="106" border="1" cellpadding="0" cellspacing="0">
<tr>
<td width="114" height="38"><div align="center">标题</div></td>
<td width="212"><div align="center">内容</div></td>
<td width="137"><div align="center">添加时间</div></td>
<td colspan="3"><div align="center">操作</div></td>
</tr>
<?php
include("conn/conn.php"); //包含conn.php文件
$select=mysql_query("select * from tb_xxgk"); //查询数据
while($row=mysql_fetch_array($select)){ //循环输出查询内容
?>
<tr>
<td height="66"><div align="center"><?php
if(strlen($row['title'])>12)
{
echo mb_substr($row['title'],0,12)."...";
}
else
{
echo $row['title'];
}
;?></div></td>
<td><div align="center"><?php
if(strlen($row['content'])>20)
{
echo mb_substr($row['content'],0,20)."...";
}
else
{
echo $row['content'];
}
;?></div></td>
<td><div align="center"><?php echo $row[fdown];?></div></td>
<td width="40"><div align="center"><a href="delete_xxgk.php?id=<?php echo $row['id'];?>"> 删除</a>
<input type="hidden" name="id" value="<?php echo $row['id'];?>"/>
</div></td>
<td width="44"><div align="center"><a href="update_xxgk.php?id=<?php echo $row['id'];?>">编辑</a>
<input type="hidden" name="id2" value="<?php echo $row['id'];?>" />
</div></td>
<td width="38"><div align="center"><a href="add_xxgk.php?id=<?php echo $row['id'];?>">添加</a>
<input type="hidden" name="id2" value="<?php echo $row['id'];?>" />
</div></td>
<!--定义隐藏域,获取id-->
</tr>
<?php
} //结束循环
?>
</table></td>
</tr>
<tr>
<td height="48"><div align="center">
本站共有公告
<?php
echo $total;
?>
条 每页显示 <?php echo $pagesize;?> 条 第 <?php echo $page;?> 页/共 <?php echo $pagecount; ?> 页
<?php
if($page>=2)
{
?>
<a href="xxgk.php?id=<?php echo $id;?>&page=1" title="首页"><font face="webdings"> 9 </font></a>
<a href="xxgk.php?id=<?php echo $id;?>&page=<?php echo $page-1;?>" title="前一页"><font face="webdings"> 7 </font></a>
<?php
}
if($pagecount<=4){
for($i=1;$i<=$pagecount;$i++){
?>
<a href="xxgk.php?id=<?php echo $id;?>&page=<?php echo $i;?>"><?php echo $i;?></a>
<?php
}
}else{
for($i=1;$i<=4;$i++){
?>
<a href="xxgk.php?id=<?php echo $id;?>&page=<?php echo $i;?>"><?php echo $i;?></a>
<?php }?>
<a href="xxgk.php?id=<?php echo $id;?>&page=<?php echo $page-1;?>" title="后一页"><font face="webdings"> 8 </font></a>
<a href="xxgk.php?id=<?php echo $id;?>&page=<?php echo $pagecount;?>" title="尾页"><font face="webdings"> : </font></a>
<?php }?>
</div></td>
</tr>
<?php };?>
</table>
</td>
</tr>
<tr>
<td height="32" background="images/right_bottom.gif"> </td>
</tr>
</table>
但是分页的作用没实现,求好心人改改
$select=mysql_query("select * from tb_xxgk"); //查询数据
while($row=mysql_fetch_array($select)){ //循环输出查询内容修改sql语句 加上limit 类似于你的
desc limit ".($page-1)*$pagesize.",$pagesize",第1个起始页面的条数 第2个要显示的数量不要跟我说不会