Otras no está funcionando

<?php
session_start();
$name=$_POST["name"];
$_SESSION['name']=$name;
$pass=$_POST["pass"];
include('db.php');
if($link==TRUE)
{
  if($dbsel==TRUE)
  {
  
  $query="select designation from registration where password='$pass' and name='$name'";
  $result=@mysql_query($query);
    
      while($row=mysql_fetch_array($result))
      {
        
  
        if($row['designation']=="admin")
        {
              
        ?>
        <script type="text/javascript">
window.location = "index_admin.php";
        </script>
        <?php
        }
        elseif($row['designation']=="customer")
        {
      
        ?>
        <script type="text/javascript">
window.location = "index_user.php";
        </script>
        <?php
        }
        //elseif($row['designation']=="xxx")
        else
        {
        echo "joy";
    echo "<script>alert('You have entered the information incorrectly, please try again or register as a new user')</script>";
      ?>
      <script type="text/javascript">
           window.location = "login.php";
           </script>
      <?php
        exit();
        }
      }
    
    
    }
  
  else
  {
  echo "Database not exist";
  }
}
else
{
echo "Connection failed";
}

?>