Jump to content

mysql_num_rows


dink87522

Recommended Posts

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

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

Archived

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

×
×
  • Create New...

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.