各位高手请教一下,我写的一个留言板,想让他每页显示两条留言,下面的程序报以下错:Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in E:\php\My php\mesboard\index.php on line 27
部分代码如下:<?php
$conn=mysql_connect("localhost","root","zzz");
mysql_select_db("guest_book");
mysql_query("set names gb2312");
$pageSize=2;
$pageNumber=$_GET['pageNumber'];
if($pageNumber==null)
$pageNumber=1;
$rs=mysql_fetch_row(mysql_query("select count(*) from contents"));
$totalCount=$rs[0];
$exec="select * from contents limit".(($pageNumber-1)*$pageSize).",2";
$result=mysql_query($exec);
while($rs=mysql_fetch_object($result))
{
echo "<table><tr><td>姓名:".$rs->name."</td></tr>";//显示姓名
echo "<tr><td>留言:".$rs->conten."</tr></td></table><br/>";//显示留言
echo
"………………………………………………………………………………………………………………………………………………………………………………………";
echo "<br/>";
}
if($pageNumber>1)
{
echo "<a href=index.php?pageNumber".($pageNumber-1).">前一页 </a>";
}
else
{
echo "前一页 ";
}
if($pageNumber<$totalCount/$pageSize)
{
echo "<a href=index.php?$pageNumber".($pageNumber+1).">后一页</a>";
}
else
{
echo "后一页";
}
mysql_close();
?>希望大家能给我帮助。
部分代码如下:<?php
$conn=mysql_connect("localhost","root","zzz");
mysql_select_db("guest_book");
mysql_query("set names gb2312");
$pageSize=2;
$pageNumber=$_GET['pageNumber'];
if($pageNumber==null)
$pageNumber=1;
$rs=mysql_fetch_row(mysql_query("select count(*) from contents"));
$totalCount=$rs[0];
$exec="select * from contents limit".(($pageNumber-1)*$pageSize).",2";
$result=mysql_query($exec);
while($rs=mysql_fetch_object($result))
{
echo "<table><tr><td>姓名:".$rs->name."</td></tr>";//显示姓名
echo "<tr><td>留言:".$rs->conten."</tr></td></table><br/>";//显示留言
echo
"………………………………………………………………………………………………………………………………………………………………………………………";
echo "<br/>";
}
if($pageNumber>1)
{
echo "<a href=index.php?pageNumber".($pageNumber-1).">前一页 </a>";
}
else
{
echo "前一页 ";
}
if($pageNumber<$totalCount/$pageSize)
{
echo "<a href=index.php?$pageNumber".($pageNumber+1).">后一页</a>";
}
else
{
echo "后一页";
}
mysql_close();
?>希望大家能给我帮助。
while($rs=mysql_fetch_object($result))
.....
}
"<a href=index.php?pageNumber".($pageNumber-1).">前一页 </a>";===> "<a href=index.php?pageNumber=".($pageNumber-1).">前一页 </a>";不一定这样改就无误,
如果运行错误,可疑的地方设置断点,打印出变量,仔细查下