joecooper Posted March 10, 2006 Share Posted March 10, 2006 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"); } Quote Link to comment Share on other sites More sharing options...
craygo Posted March 10, 2006 Share Posted March 10, 2006 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 errorRay Quote Link to comment Share on other sites More sharing options...
joecooper Posted March 10, 2006 Author Share Posted March 10, 2006 oops, missed out the db include!cheers Quote Link to comment Share on other sites More sharing options...
craygo Posted March 10, 2006 Share Posted March 10, 2006 Cool dealAlways something stupid, After looking at your code long enough everything starts to get jumbled together. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.