login page using php

<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>insert title here</title>
</head>
<body>
<h1>login page</h1>
<form action ="LOGO.php" method="post">
user name:<input type="text" name="uname">
password:<input type=text" name="pass">
<input type="submit" value="login">
</form>
</body>
</html>

php file

<?php
$username="root";
$password="";
$database="login";

$first=$_POST["uname"];
$pa=$_POST["pass"];
$con=mysql_connect("localhost",$username,$password);
mysql_select_db("login",$con);

$query="select * from log";
$result=mysql_query($query);

$f=1;
while($row=mysql_fetch_array($result))
{
 if($row['uname']==$first && $row['pass']==$pa)
{
 $f=2;
}
}
if($f==1)
{
 echo "login not correct";
}
else
{
 echo "correct";
 header("location:success.html");
}
mysql_close();
?>

success page

<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
</html>
<body>
<h1>success
<br>
login correct</h1>
</body>
</html>