Login error

[skoobi]

Hi im getting this error when i try to login via a login tutorial that i found...

 

'PHP Warning:  mysql_num_rows() expects parameter 1 to be resource, boolean given in dir_structure/checklogin.php on line 31'

 

The code for that file is:

<?php
ob_start();
require_once 'includes/db.php';
// Connect to server and select databse.
mysql_connect("$dbHost", "$dbUser", "$dbPass")or die("cannot connect");
mysql_select_db("$dbDatabase")or die("cannot select DB");

// Define $myusername and $mypassword
$myusername=$_POST['username'];
$mypassword=$_POST['password'];

// To protect MySQL injection (more detail about MySQL injection)
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);

$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);

// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1){

// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("myusername");
session_register("mypassword");
header("location:login_success.php");
}
else {
echo "Wrong Username or Password";
}

ob_end_flush();
?>

 

Does anyone know what this could be... Ive googled it and found all sorts of different things for it...

 

Cheers

Chris

[Deoctor]

this could happen for different reasons..

 

one is that if u have any one value of the inputs be empty..

$myusername

$mypassword

 

or else the $sql does not return any values to the query which u have written..

 

 

just check like this

echo $sql

 

this will give u the query which u are running..

 

run the same in the mysql and see if u get the results

[askbapi]

Take a test and see the fault. Do this 1st:

 

> echo $sql;

 

> Than copy the sql string and run in MYSQL and see what is wrong.

 

The problem is with SQL string