login user name and password

login user name and password:
When status=off and username &passwor  matched  then it will show not active
When status=off and username &passwor does not match  then it will show not active 
When status=onand username &passwor   then it will show active and jump to same page or anotheer page


<?php
include("connect.php");     //your connection

if(isset($_POST["username"])){$name=$_POST["username"];
if(isset($_POST["password"])){$password=$_POST["password"];}
if($name=="" || $password=="" ){
$repage="index.php?flag1=blank";
}
else{
mysql_select_db($database_logincon, $logincon);
$query_1 = "SELECT * FROM login where name ='$name' AND password='$password'";
$Record1 = @mysql_query($query_1, $logincon) or die(mysql_error());
$row_Record1 = mysql_fetch_assoc($Record1);
$sno=$row_Record["sno"];
$name1=$row_Record1["name"];
$pass1=$row_Record1["password"];
    $status1=$row_Record1["status"];
$usertype1=$row_Record1["usertype"];
mysql_free_result($Record1);
if($name1!=$name or $pass1!=$password or $status1!='on'){
$repage ="index.php?flag1=notactive";
}
elseif($usertype1=='admin' && $status1=='on'){
$_SESSION["loginvar1"]=$name;
$repage="index.php?flag1=holdadminpanel";
}
elseif($usertype1=='user' && $status1=='on'){
$_SESSION["loginvar1"]=$name;
$_SESSION["loginvar"]=$sno;
$repage="index.php?flag1=success";
}
}}
echo "<script>window.open('$repage',target='_self');</script>";
?>