mysql_num_rows() expects parameter 1 to be resource, boolean

[roughneck86]

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...

[rajivgonsalves]

you should use some error handling e.g

 

 

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

 

 

[Maq]

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.