Jump to content

Archived

This topic is now archived and is closed to further replies.

joecooper

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

Recommended Posts

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");
}

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
Cool deal
Always something stupid, After looking at your code long enough everything starts to get jumbled together.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.