Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/essexrac/public_html/joe/projectx/login.php on line 33

[joecooper]

cannot understand why it gives that error!. other pages with that code works fine.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/essexrac/public_html/joe/projectx/login.php on line 33


$sql="SELECT * FROM users WHERE username='$username' AND password='$password'"; //get rows where the username feild matches the username or email feild in the database with same password
$result=mysql_query($sql);
//if there was a row returned, then obiously there is an account with the correct username/password. They may login!
if (mysql_num_rows($result) == 1){
$_SESSION['loggedin']="TRUE"; //set the global session varible for loggedin to true
die("Welcome $username! You are now logged in");
}

[craygo]

That usually means there is a problem with your select statement and error return to see.

change this
[code]$result=mysql_query($sql);[/code]

to this
[code]$result = mysql_query($sql) or die (mysql_error());[/code]

Then post error

Ray

[joecooper]

oops, missed out the db include!
cheers

[craygo]

Cool deal
Always something stupid, After looking at your code long enough everything starts to get jumbled together.