mysql_num_rows expects parameter 1

mysql_num_rows expects parameter 1

• 軟體兄弟
• expects parameter 1 to be resource boolean given
• 文章資訊

This error is because the previous call to mysql_query is not producing a result set, but a false stating that the query had failed. mysql_query() or die(mysql_error());. to see the problem. try the above code. From the code you have posted $tbl_name is ,There might be two possible issues in your code. First, the variable $user might be empty. So test it if it is null. <?php if(empty($user)) //do not continue; } ?> Second might be, you are not connected to mysql. You can correct it like this. <?p, I suspect you mean SELECT * FROM user ... , not SELECT * FROM $user ... (remove the $ ), which is causing your error. mysql_query() returns false if the query failed, which is what you would expect if $user doesn't contain the name of your table. Tha, you are mixing mysql with mysqli . change this if (mysql_num_rows($result) > 0). to if (mysqli_num_rows($result) > 0)., This means the MySQL query did not execute correctly. You can use this to figure out what went wrong: $rs = mysql_query( "select * from users where fb_userid='$fb_user'" ) or die(mysql_error());. although in this case it seems the probl, $checkquestion = mysql_query("SELECT question_text FROM questions LIKE '$questions' "); if (!$checkquestion) die(mysql_error()); }. Next step: Fix your SQL query. You must always check whether a query succeeded or not. There are a mill, Change: $check = mysql_query("SELECT * FROM Test WHERE username = '$username'");. to $check = mysql_query("SELECT * FROM Test WHERE username = '$username'") or die(mysql_error());. And you will see any potential errors, You have not actually executed your query: $query = "SELECT username FROM $this->table WHERE username='$sUser'"; $doesFieldExist = false; // Execute the query with mysql_query() $result = mysql_query($query); // $result is a result r, Deprecated: mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:-wamp-www-shop.php on line 27 ( ! ) Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:-wamp-www-

相關軟體 MySQL 資訊

MySQL 是一個開源的 RDBMS（關係數據庫管理系統），它支持用 C，C ++，Java，Perl 和 PHP 等各種編程語言編寫的請求。由於其高速度和靈活性，MySQL 已成為主要用於開發各種形狀和大小的 Web 應用程序的最流行的數據庫系統之一。自 1995 年上市以來，這種非常受歡迎的開源數據庫管理系統已經應用於當今幾乎所有互聯網用戶的無數項目中。今天一些最受歡迎的 MySQL 用戶是 ... MySQL 軟體介紹 mysql_num_rows expects parameter 1 相關參考資料 mysql - Warning: mysql_num_rows() expects parameter 1 to be ... This error is because the previous call to mysql_query is not producing a result set, but a false stating that the query had failed. mysql_query() or die(mysql_error());. to see the problem. try the ... https://stackoverflow.com php - mysql_num_rows() expects parameter 1 to be resource, boolean ... There might be two possible issues in your code. First, the variable $user might be empty. So test it if it is null. <?php if(empty($user)) //do not continue; } ?> Second might be, you are not c... https://stackoverflow.com PHP Warning: mysql_num_rows() expects parameter 1 to be resource ... I suspect you mean SELECT * FROM user ... , not SELECT * FROM $user ... (remove the $ ), which is causing your error. mysql_query() returns false if the query failed, which is what you would expect i... https://stackoverflow.com php - mysql_num_rows() expects parameter 1 to be resource error ... you are mixing mysql with mysqli . change this if (mysql_num_rows($result) > 0). to if (mysqli_num_rows($result) > 0). https://stackoverflow.com mysql - PHP Warning: mysql_num_rows() expects parameter 1 to be ... This means the MySQL query did not execute correctly. You can use this to figure out what went wrong: $rs = mysql_query( "select * from users where fb_userid='$fb_user'" ) or die(my... https://stackoverflow.com php - How to fix this :"Warning: mysql_num_rows() expects ... $checkquestion = mysql_query("SELECT question_text FROM questions LIKE '$questions' "); if (!$checkquestion) die(mysql_error()); }. Next step: Fix your SQL query. You must always c... https://stackoverflow.com php - mysql_num_rows() expects parameter 1 to be resource, string ... Change: $check = mysql_query("SELECT * FROM Test WHERE username = '$username'");. to $check = mysql_query("SELECT * FROM Test WHERE username = '$username'") or die... https://stackoverflow.com php - mysql_num_rows giving error "mysql_num_rows() expects ... You have not actually executed your query: $query = "SELECT username FROM $this->table WHERE username='$sUser'"; $doesFieldExist = false; // Execute the query with mysql_query() ... https://stackoverflow.com mysql練習一只回傳錯誤的訊息- PHP新手區相關討論於台灣PHP聯盟 ... Deprecated: mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:-wamp-www-shop.php on line 27 ( ! ) Warning: mysql_num_rows() expects pa... https://twpug.net