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

Question

this is my code i learned this via a tutorial so this is not my own code but what did i do wrong?

i look forward to hearing from you guys

opening php tag

$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!';
}

closing php tag

Answer 1

use mysql_error :-

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