Login Process in php

Login Process in php for online library mgt system

<?php

$conection=mysql_connect("localhost","root","");

if(!$conection)

echo"failed";

else

mysql_select_db("lms",$conection);

$user=$_POST['uname'];

$pswd=$_POST['password'];

if(!$user||!$pswd)

{

echo"Please enter username and password";

}

else

{

if($user=="Administrator" && $pswd=="administrator")

header('Location: bookregister.php');

else

{

$query = "SELECT * FROM student WHERE userName = '$user' AND pasword = '$pswd'";

$results = mysql_query($query);

if(mysql_num_rows($results) <= 0)

echo"failed";

else

header('Location: booksearch.php');

}

}

mysql_close($conection);

?>