Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in E:\php\AMP-Bugfree\www\liuyanben\index.php on line 24
这是怎么回事怎么解决啊?麻烦大家乐
<?php
$id=mysql_connect("localhost","root","");
mysql_select_db("liuyanben",$id);
$query="select * form message";
$result=mysql_query($query ,$id);
if(mysql_num_rows($result)<1){
echo " 目前还没有任何留言!";
}else{
$totalnum=mysql_num_rows($result);
$pagesize=10;
$page=$_GET["page"];
if($page==""){
$page=1;}
$begin=($page-1)*$pagesize;
$totalpage=ceil($totalnum/$pagesize);
echo "<table boder=0 width=95%><tr><td>";
$datanum=mysql_num_rows($result);
echo "共有留言".$totalnum."条。";
echo "每页".$pagesize."条,共".$totalpage."页<br>";
for($j=1;$j<=$totalpage;$j++){
echo "<a herf=manage.php?page=".$j.">[".$j."] </a>";}
echo"<br>";
$query="select * form message order by addtime desc limit $begin,$pagesize";
$result=mysql_query($query ,$id);
for($i=1;$i<=$datanum;$i++){
$info=mysql_fetch_array($result,MYSQL_ASSOC);
echo"->[".$info['author']."]于".$info['addtime']."说:<br>";
echo" ".$info['content']."<br>";
if($info['reply']!=""){
echo"<b>管理员回复:</b>".$info['reply']."<br>";}
echo "[<a href=manage.php?delid=".$info['id'].">删除此留言</a>]
[<a href=reply.php?id=".$info['id'].">回复留言</a>]";
echo "<hr>";
}
echo "</table>";
}
mysql_close($id);
?>
这是怎么回事怎么解决啊?麻烦大家乐
<?php
$id=mysql_connect("localhost","root","");
mysql_select_db("liuyanben",$id);
$query="select * form message";
$result=mysql_query($query ,$id);
if(mysql_num_rows($result)<1){
echo " 目前还没有任何留言!";
}else{
$totalnum=mysql_num_rows($result);
$pagesize=10;
$page=$_GET["page"];
if($page==""){
$page=1;}
$begin=($page-1)*$pagesize;
$totalpage=ceil($totalnum/$pagesize);
echo "<table boder=0 width=95%><tr><td>";
$datanum=mysql_num_rows($result);
echo "共有留言".$totalnum."条。";
echo "每页".$pagesize."条,共".$totalpage."页<br>";
for($j=1;$j<=$totalpage;$j++){
echo "<a herf=manage.php?page=".$j.">[".$j."] </a>";}
echo"<br>";
$query="select * form message order by addtime desc limit $begin,$pagesize";
$result=mysql_query($query ,$id);
for($i=1;$i<=$datanum;$i++){
$info=mysql_fetch_array($result,MYSQL_ASSOC);
echo"->[".$info['author']."]于".$info['addtime']."说:<br>";
echo" ".$info['content']."<br>";
if($info['reply']!=""){
echo"<b>管理员回复:</b>".$info['reply']."<br>";}
echo "[<a href=manage.php?delid=".$info['id'].">删除此留言</a>]
[<a href=reply.php?id=".$info['id'].">回复留言</a>]";
echo "<hr>";
}
echo "</table>";
}
mysql_close($id);
?>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货