i log in to test my login script it gos to run the check_login.php script
and i get this error
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/jaccbpac/public_html/classnest/check_login.php on line 22
Wrong Email Or Password
<?php
include "db.php";
?>
<?php
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$email=$_POST['email'];
$password=$_POST['password'];
$email = stripslashes($email);
$password = stripslashes($password);
$email = mysql_real_escape_string($email);
$password = mysql_real_escape_string($password);
$sql="SELECT * FROM $tbl_name WHERE email='$email' and password='$password'";
$result = mysql_query($sql);
$count = mysql_num_rows($result);
if($count == 1){
session_register("email");
session_register("password");
header("location:login_success.php");
}
else{
echo "Wrong Email Or Password";
}
?>