$sql_username_validate="SELECT * FROM user WHERE username='$username' AND password='$password'";
$result=mysql_query($sql_username_validate,$conn);
$count=mysql_num_rows($result);
echo $count;
if($count==1)
{
  echo "YES";
  header ('Location:../user/index.php');
}
else
{
header ('Location:../signin.php');
}