anlye
(anlye)
新手上路
初级会员
UID 8403
精华
0
积分 11
帖子 5
金钱 11 喜悦币
威望 0
人脉 0
阅读权限 10
注册 2001-5-30
状态 离线
|
mysql_num_rows()错误，请教解决
代码如下：
<?
include("../system/mysql.inc");//数据库登录信息，密码等
if($ordersn!='')
{ if($cussn!='')
{ $query="select * from customer where CUSNO=$cussn";
$result=mysql_query($query);
if(mysql_num_rows($result)==0)//此行出错
echo "无此编号";
else
{ $r=mysql_fetch_array($result);
$Rshort=$r['SHORT'];
$query="INSERT INTO orderon (ORDNO,CUSNO,SHORT,ODATE,STA) VALUES
('$ordersn','$cussn','$Rshort',new(),'未完成')";
$result=mysql_query($query);
if(mysql_affected_rows()==1)
echo "$code 已经添加!";
}
}
else
echo "请输入客户编号！";
}
$query="select * from orderon";
$result=mysql_query($query);
if(mysql_num_rows($result)==0)
{
echo "无记录";
}else
{
echo "<table width=600>";
echo "<tr><td>定单号</td><td>客户编号</td><td>客户名称</td><td>下单日期</td><td>完成日期</td><td>完成状况</td><td>操作</td></tr>";
while($r=mysql_fetch_array($result))
{
$orfno=$r["ORDNO"];
$cusno=$r['CUSNO'];
$odate=$r['ODATE'];
$fdate=$r['FDATE'];
$sta=$r['STA'];
$short=$r['SHORT'];
echo "<tr>";
echo "<td>$orfno</td>";
echo "<td>$cusno</td>";
echo "<td>$short</td>";
echo "<td>$odate</td>";
echo "<td>$fdate</td>";
echo "<td>$sta</td>";
echo "<td>编辑 删除</td>";
echo "</tr>";
}
echo "</table>";
echo "<form action=# method=post><table width=480 border=0>";
echo "<tr><td>定单号：</td><td><input type=text name=ordersn></td><td>定单编号</td></tr>";
echo "<tr><td>客户号：</td><td><input type=text name=cussn></td><td>客户编号</td></tr>";
echo "<tr><td> </td><td><input type=submit value=添加><input type=reset value=重置></td><td> </td></tr>";
echo "</table>";
echo "</form>";
}
?>
按“添加”按扭后执行，出现如下错误
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/clients/weitai/wwwroot/admin/dingdan.php on line 7
请问是怎么回事
|
|
