มีคำถามเรื่องระบบล๊อคอินครับผม มือใหม่ php วานผู้รู้ทีครับผม

<?php 
$username = $_POST["username"];
$password = $_POST["password"];
$hostname="localhost";
$user="root";
$passwordd="1234";
$dbname="datatest";
$tbname="member";
mysql_connect($hostnamet,$user,$passwordd) or die("Not Connection Mysql");
mysql_select_db($dbname) or die("Not Select Date Base");
mysql_query("SET character_set_results=utf8");
mysql_query("SET character_set_client=utf8");
mysql_query("SET character_set_connection=utf8");
$sql=sprintf("SELECT * FROM `member` WHERE username = '".$username."'");
//echo $sql."<br>";
$dbquery=mysql_db_query($dbname,$sql);
while($result = mysql_fetch_array($dbquery)){
if($password == $result["password"]){
	$_SESSION["username"] = $username;
	$_SESSION["status"] = $result["status"];
}
}
if(isset($_SESSION["username"]) && isset($_SESSION["status"])){
	if($_SESSION["status"] == "1"){
 header( "location: homepageTeacher.php" );
 }
  else if($_SESSION["status"] == "2"){
header( "location: homepageStudent.php" );
}
}
else{
echo "กรุณาใส่ username และ  password ให้ถูกต้อง";	
}
?>