获取?后的变量,不能分页,第一页显示正常(急啊！！！！！！！！)
大家好,请问一下啊。我获取?后的变量,不能分页,第一页显示正常？？？？http://localhost:8080/yuanji/SubPhotosShow.php?id=1
显示正常~~~~~~
http://localhost:8080/yuanji/SubPhotosShow.php?page=2
不能正常显示~~~~~~~~~~
错误如下:
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\yuanji\SubPhotosShow.php on line 25
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\yuanji\SubPhotosShow.php on line 29
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\yuanji\SubPhotosShow.php on line 52
页次：1/0页 记录： 条
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\yuanji\SubPhotosShow.php on line 77
代码：
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.
<html xmlns="http://www.
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<body>
<table width="550" border="1" cellpadding="1" cellspacing="1" bordercolor="#FFFFFF" bgcolor="#999999">
<?php
//获取传过来的变量
$id=$_GET['id'];
include("DBhelper.php");
$i=1;
if ($page=="")
{
$page=1;
}
if (is_numeric($page))
{
$page_size=4;
$query="select count(*) as total from photos where TypeId=$id order by Id asc";
$result=mysql_query($query); //查询符合条件的记录总条数
$message_count=mysql_result($result,0,"total"); //要显示的总记录数
$page_count=ceil($message_count/$page_size); //根据记录总数除以每页显示的记录数求出所分的页数
$offset=($page-1)*$page_size; //计算下一页从第几条数据开始循环
$sql=mysql_query("SELECT Id,PhotoName,TypeId FROM photos where TypeId=$id order by Id asc limit $offset, $page_size");
$row=mysql_fetch_object($sql);
do
{
?>
<!-- 往不同的表格插入不同的数据-->
<?php
if($i%2!=0)
{
echo '<tr bgcolor="#ffffff"><td>';
echo '<a href="'.'http://www.'.'">'.'<img width="148" height="98" border="0" src="./images/'.$row->PhotoName.'" /></a>';
echo '</td>';
}
else if($i%2==0)
{
echo '<td>';
echo '<a href="'.'http://www.'.'">'.'<img width="148" height="98" border="0" src="./images/'.$row->PhotoName.'" /></a>';
echo '</td></tr>';
}
?>
<?php
$i++;
}
while($row=mysql_fetch_object($sql));
}
?>
</table>
<br>
<table width="550" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="37%"> 页次：<?php echo $page;?>/<?php echo $page_count;?>页 记录：<?php echo $message_count;?> 条 </td>
<td width="63%" align="right">
<?php
//如果当前不是首页
if($page!=1)
{
/* 显示“首页”超链接 */
echo "<a href=SubPhotosShow.php?page=1>首页</a> ";
/* 显示“上一页”超链接 */
echo "<a href=SubPhotosShow.php?page=".($page-1).">上一页</a> ";
}
if($page<$page_count)
{
/* 显示“下一页”超链接 */
echo "<a href=SubPhotosShow.php?page=".($page+1).">下一页</a> ";
/* 显示“尾页”超链接 */
echo "<a href=SubPhotosShow.php?page=".$page_count.">尾页</a>";
}
mysql_free_result($sql);
mysql_close($conn);
?>
</td>
</tr>
</table>
</body>
</html>
