Login Page in PHP is not working

\[code\]<body><?php session_start(); function salt($pw) { $salt = "This comment should suffice as salt."; return sha1($salt.$pw); } if (isset($_POST['submit'])) { $link = mysql_connect('localhost', 'codekadiya', 'pass'); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; mysql_close($link); $username = mysql_real_escape_string($_POST['username']); $password = mysql_real_escape_string($_POST['password']); $password = salt($password); $query = mysql_query("SELECT * FROM test WHERE username='$username' AND password='$password'"); if (mysql_num_rows($query)== 0) { header("location:register.php"); exit; } else { $_SESSION['user'] = $username; header("location: register.php"); } }?></body>\[/code\]I checked on my Connection. It says connection successful but I cant figure out what the other mistake are. Can someone guide me the mistake I have done? I can't find it.
 
Top