mysql_num_rows() expects parameter 1 to be resource, boolean
Posted: Tue Dec 22, 2009 6:57 am
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...
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...