php 密码简单,php – 简单的登录检查密码

我在这做错了什么：

if (isset($_POST['submitted'])) {

$errors = array();

require_once ('mysql_connect.php');

session_start();

$username = $_POST["username"]; // This is the inputted username from the form in Login.html

$password = $_POST["password"]; // This is the inputted password from the form in Login.html

if (empty($errors)) {

$query="SELECT username FROM users WHERE username='$username' AND password='SHA($password)'";

$result = mysql_query($query);

// Mysql_num_row is counting table row

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

$_SESSION["username"] = $username; // Creates a cookie saving the username

$_SESSION["loggedIn"] = true; // Creates a cookie saying the user is logged in

// Show thank you message

echo '

Thank You!

You have been logged in.';

} else {

echo 'You could not be logged in, please make sure your username and password is correct.';

foreach ($errors as $msg) {

echo " - $msg
\n";

}

}

} else {

echo '

Error!

The following error(s) occured:
';

foreach ($errors as $msg) {

echo " - $msg
\n";

}

}

}

?>

我得到一个：

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /login.php on line 19

我的密码是否正确？