PHP Code:

<?php
$user
="";
$pass="";
$database="phpdb";

$username=$_POST['username'];
$password=$_POST['password'];

mysql_connect('localhost',$user,$pass);
@
mysql_select_db($database) or die ("error selecting DB");

if(
$username == "admin")
{
   if(
$password == "test")
   {
   echo 
"Admin Login";
   }
   else
   {
   echo 
"Error Incorrect Admin Password";
   }
}
else
{

     
$query="SELECT password FROM clients WHERE username='$username'";
     
$result=mysql_query($query) or die (mysql_error());

     if (
$result==$password)
        {
        echo 
"Welcome";
        }
      else
        {
        echo 
"Error";
        }
}
mysql_close();
?>
this doesnt work, it works if the admin logs in i think its the way i am handling the $result could any help me fix it up?

thank you