<?php
//Database Information
$dbhost = "localhost";
$db = "dbname";
$dbuser = "root";
$dbpass = "";
//Connect to database
mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($db) or die(mysql_error());
session_start();
{
$username = $_POST['username'];
$password = md5($_POST['password']);
$query = "select username from users where username=’$username’ and password=’$password’";
$result = mysql_query($query);
if(mysql_num_rows($result)!=1)
{
$error = "Bad Login";
include "loginform.php";
} else {
$_SESSION['username'] = "$username";
include 'members.php';
}
}
?>
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean.
Sir,above error occur in my login.php page. I don't understand this error how can i solve this error. please help me.