Im having a problem with my login.php which says "result found: 1
User does not exist! Please try again!" but i have been able to register and see the data in my database.
This is my login.php. can any body tell me why im getting that error?
<?php
$v_username = addSlashes($POST['username']);
$v_password = addSlashes(md5($POST['password']));
if($POST['username']=="" || $POST['password']=="")
{
echo "Please, you must supply username and password fields!";
}
else
{
$conn = mysql_connect("localhost","USERNAME","PS") or die ("Couldnt connect to database");
if (!$conn)
{
die('Could not connect: ' . mysql_error());
}
else
{
mysql_select_db("DATABASE",$conn) or die ("Couldnt find database");
$result = mysql_query("SELECT * FROM users WHERE username='$v_username'");
$intResultCount=count($result);
echo "result found: ". $intResultCount ."<br />";
if ($intResultCount==1)
{
if( $v_username != $result['username'])
{echo "User does not exist!" . " ". "Please try again!";}
elseif ($result['username'] == $v_username && $result['password'] == $v_password)
{
echo "Congratulations". " " . $v_username . "!"."<br />";
echo "You have successfully logged in!";
echo $intResultCount . "<br />";
}
else
{echo "The password is invalid! Please try again.";}
}
}
}
?>
