Hi, I'm have created a simple login form and had it working fine. Then suddenly, although nothing was changed it threw up this error:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\checklogin.php on line 49
and I just can't seem to solve the problem. Here is my code:
<?php
// Connect to server and select databse.
mysql_connect("localhost","root","bexwilkins");
//specify database
mysql_select_db("main") or die("Unable to select database");
// username and password sent from form
$user=$_POST['user'];
$pass=$_POST['pass'];
// To protect MySQL injection
$user = stripslashes($user);
$pass = stripslashes($pass);
$user = mysql_real_escape_string($user);
$pass = mysql_real_escape_string($pass);
$sql = "SELECT * FROM user WHERE user='$user' AND pass='$pass'";
$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
//session_start();
session_register("user");
session_register("pass");
header("location: addEvent.php");
}
else
{
echo "Wrong Username or Password";
}
?>
Please help me!!
Thank youuu
php login error
Moderator: General Moderators
Re: php login error
Code: Select all
if(!$result = mysql_query($sql))
{
echo mysql_error();
}
Re: php login error
$count=mysql_num_rows($result);
replace above with
$count = mysql_affected_rows();
replace above with
$count = mysql_affected_rows();
Re: php login error
print the query and check it, its error from query. try that printed query directly in phpmyadmin
-
Paul Arnold
- Forum Contributor
- Posts: 141
- Joined: Fri Jun 13, 2008 10:09 am
- Location: Newcastle Upon Tyne
Re: php login error
Maybe don't post your database password on a public forum too 
Also, session_start(); has been commented out.
Also, session_start(); has been commented out.