Problem

[zachary]

<?phpinclude("mysql_connect.php");$username = $_POST['username'];$password = $_POST['password'];$pass_md5 = md5($password);$query = mysql_query("SELECT * FROM usersWHERE user='$username' AND pass = '$pass_md5'") or die(mysql_error());if(mysql_num_rows($query) != null)	{	echo "That password is correct.";	}else{echo "That username or password is wrong.";}?>

It will give me the "That username or password is wrong." error no matter what. Help please

[justsomeguy]

mysql_num_rows never returns null. If there are no rows, it returns 0. If there is an error, it returns boolean false.

[zachary]

So whats the fix?

[jhecht]

<?phpinclude("mysql_connect.php");//Im assuming in mysql_connect.php there is a line that says $myConnect = mysql_connect()$username = $_POST['username'];$password = $_POST['password'];$pass_md5 = md5($password);$query = mysql_query("SELECT * FROM usersWHERE user='$username' AND pass = '$pass_md5'",$myConnect) or die(mysql_error());if(mysql_num_rows($query) != 0)	{	echo "That password is correct.";	}else{echo "That username or password is wrong.";}?>