i want seperate error messages for username and password ..but in below code i am not getting ..can anybody check this and make changes ...thanks
<html>
<head>
</head>
<body>
<form action='login.php' method='post'>
User name:<input type='text' name='name'/>
Password:<input type='password' name='pwd'/>
<input type='submit' name='submit' value='Submit'/>
</form>
<?php
session_start();
if(isset($_POST['submit']))
{
mysql_connect('localhost','root','saibaba92@');
mysql_select_db('new');
$name=$_POST['name'];
$pwd=$_POST['pwd'];
if($name != '' && $pwd != '')
{
$query=mysql_query("select * from login1 where Name='$name' AND password='$pwd'");
$sql=mysql_fetch_array($query);
if(($sql['Name']==$name)&&($sql['password']==$pwd))
{
$_SESSION['name']=$name;
header("Location:welcome.php");
}
else if(($sql['password']==$pwd)&&($sql['Name']!=$name))
{
echo 'username is incorrect';
}
else{
echo 'password is incorrect';
}
}
else
{
echo'Enter both username and password';
}
}
?>
</body>
</html>