mysql_num_rows

[dink87522]

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

[GingerRobot]

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

[dink87522]

Thanks, that is a very handy tip