作者idcomputer (大顺)
看板PHP
标题[请益]supplied argument isnot a valid MySQL result resource问题
时间Fri Feb 1 21:16:00 2008
$sqlstr1 = "SELECT * FROM twodata ORDER BY sd ASC";
$res1 = mysql_query($sqlstr1);
$row1 = mysql_fetch_assoc($res1);
$totalRows1 = mysql_num_rows($res1);
<==187
$sqlstr2 = "SELECT * FROM twodata"; <==188
$res2 = mysql_query($sqlstr2);
$row2 = mysql_fetch_assoc($res2);
$totalRows2 = mysql_num_rows($res2);
连续送出两次的查询!!!
下方的阵列有正常显示
不过网页却出现
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL
result resource in C:\AppServ\www\two.php on line 187
Warning: mysql_num_rows(): supplied argument is not a valid MySQL
result resource in C:\AppServ\www\two.php on line 188
想请问问题是出在?!
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 61.221.166.118
1F：推 linrobz:第一个直觉...SQL语法有没有那里打错？ 02/02 00:57