dink87522 Posted January 2, 2010 Share Posted January 2, 2010 The below code gives the error "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/obama/public_html/picks/loginProcess.php on line 20" Why, or what do I need to do to avoid this/fix it? <?php // loginProcess.php session_start(); $user = $_POST["user"]; $pass = $_POST["pass"]; $_SESSION['login'] = 0; $servername = "localhost"; $username = "*******"; $password = "********"; $dbCon = mysql_connect($servername, $username, $password); if (!$dbCon) { die(); } mysql_select_db("*****") or die(mysql_error()); $sql="SELECT * FROM users WHERE userName='$user' and passwod='$pass'"; $result=mysql_query($sql); $count = mysql_num_rows($result); if($count == 1){ $_SESSION['user'] = $user; $_SESSION['login'] = 1; echo("logged in"); }else{ $_SESSION['error'] = "Invalid username or password. Please try again."; echo("not logged in"); } ?> Link to comment https://forums.phpfreaks.com/topic/186914-mysql_num_rows/ Share on other sites More sharing options...
GingerRobot Posted January 2, 2010 Share Posted January 2, 2010 This means there is a problem with your query and mysql_query() has returned false. You should add some debugging code to your call to mysql_query(): $result = mysql_query($sql) or trigger_error(mysql_error() . "<br> Query was: " . $sql , E_USER_ERROR); Link to comment https://forums.phpfreaks.com/topic/186914-mysql_num_rows/#findComment-987050 Share on other sites More sharing options...
dink87522 Posted January 2, 2010 Author Share Posted January 2, 2010 Thanks, that is a very handy tip Link to comment https://forums.phpfreaks.com/topic/186914-mysql_num_rows/#findComment-987051 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.