我得到这个错误代码警告:mysql_num_rows()期望参数1是resource,在第19行/home/koloyx


i get this error code Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/koloyxlj/public_html/login.php on line 19

这是我的代码,我是通过教程学习的,所以这不是我自己的代码,但我做错了什么?

我期待着你们的来信

打开php标签

$username = "";
$password = "";
$hostname = "";
$dbhandle = mysql_connect($hostname, $username, $password) or die ("Really could not connect to database!");
$selected = mysql_select_db("login", $dbhandle);
$myusername = $_POST['user'];
$mypassword = $_POST['pass'];
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$query = "SELECT * FROM Users WHERE Username='$myusername' and Password='$mypassword'";
$result = mysql_query($query);
$count = mysql_num_rows($result);
mysql_close();
if($count==1) {
    echo 'It worked!';
}

关闭php标记

使用mysql_error:-

$query = "SELECT * FROM Users WHERE 
Username='$myusername' and Password='$mypassword'";
$result = mysql_query($query);
if(!$result)
die(mysql_error($dbhandle));