login form does not output error messages

[deepg]

I have some problem this code. plz check and correct this code. My problem is If write wrong user id and password automatically enter my url not show the error message invalid user id or password.plz solve my problem early send my email full code using this database.

this is login page code login.php

 //Database Information
 
$dbhost = "localhost";
$dbname = "_MUNGED_";
$dbuser = "_MUNGED_";
$dbpass = "_MUNGED_";
 
//Connect to database
 
mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());
 
session_start();
$username = $_POST[‘username’];
$password = md5($_POST[‘password’]);
 
$query = “select * from users where username=’$username’ and password=’$password’”;
 
$result = mysql_query($query);
 
if (mysql_num_rows($result) = 0) {
$error = “Bad Login”;
    include “login.html”;
 
} else {
    $_SESSION[‘username’] = “$username”;
    include “memberspage.php”;
}
 
?>

[ak1dnar]

Welcome to TSDN.

You have to echo the error messages.

echo $error;

[pbmods]

Heya, DeepG. Welcome to TSDN!

Changed thread title to better describe the problem (did you know that threads whose titles contain phrases such as, 'problem' actually get FEWER responses?).

I went ahead and removed the database login info from your post for your protection.

TSDN members are expected to write their own code. We're happy to help you out if you have specific questions, but you can't realistically expect someone to do your coding for you on a free forum.

Good idea to put your content on a separate page from the backend. Since you're already doing that, consider using header() redirection instead of include() so as to get rid of the annoying "Are you sure you want to resubmit POST data?" browser warning when the User refreshes the page or presses the back button.