[請益]supplied argument isnot a valid MySQL result resource問題

看板PHP作者 (大順)時間18年前 (2008/02/01 21:16), 編輯推噓1(100)
留言1則, 1人參與, 最新討論串1/1
$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

02/02 00:57, , 1F
第一個直覺...SQL語法有沒有那裡打錯?
02/02 00:57, 1F
文章代碼(AID): #17enkH6V (PHP)
文章代碼(AID): #17enkH6V (PHP)