checklogin.php error
Posted: Tue Feb 24, 2009 4:19 pm
Hi Guys
This page worked perfectly until I ammended it slightly, then it came up with an error message, now after removing the ammendment I made the same error message appears whether I type in the correct login details or the wrong ones...?
Why am I getting this error:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/picfrisky.com/httpdocs/checklogin.php on line 21
Wrong Username or Password
This page worked perfectly until I ammended it slightly, then it came up with an error message, now after removing the ammendment I made the same error message appears whether I type in the correct login details or the wrong ones...?
Code: Select all
<?php
// Connect to server and select databse.
include_once "functions.php";
connect();
// username and password sent from form
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];
// To protect MySQL injection (more detail about MySQL injection)
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);
$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password=MD5('$mypassword')";
$result=mysql_query($sql);
// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1){
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("myusername");
session_register("mypassword");
header("location:login_success.php");
}
else {
echo "Wrong Username or Password";
}
?>Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/picfrisky.com/httpdocs/checklogin.php on line 21
Wrong Username or Password