Jump to content

mysql_num_rows() expects parameter 1 to be resource, boolean


roughneck86

Recommended Posts

what's wrong with my codes??

it say's "mysql_num_rows() expects parameter 1 to be resource, boolean given"

-----------------

$log_username = $_POST['username'];

$log_password = $_POST['password'];

 

$sql_user_verify = "SELECT COUNT(*) FROM users WHERE username= '$log_username' AND password = '$log_password'";

 

$user_result = mysql_query($sql_user_verify,$conn);

 

if(mysql_num_rows($user_result) == 1) {

//login successfull

}

----------------

 

my plan is to crete login form and check it in database and verify it...

Hi roughneck86,

 

Please surround your code with


tags when posting code.

If there is an error with your query then mysql_error will return FALSE, which is a boolean, and explains your error.

You should echo "$sql_user_verify" to see what exactly the query is.

 

you should use some error handling e.g

 

 

$user_result = mysql_query($sql_user_verify,$conn) or die('Cannot Execute:'. mysql_error());

 

 

 

While I agree with error handling, it's better to use [/m]trigger_error[/m] rather than totally killing the script by using or die.

 

*Moving to the MySQL section as I believe there's something wrong with your query.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.