PHP inserting data.....................................?

[imported_blue_angle]

$qry= "SELECT * FROM members";
if ($qry){
$qry = "INSERT INTO members(firstname, lastname, login, passwd,type) VALUES('$fname','$lname','$login','".md5($_POST['password'])."','$type')";
if ($qry[4]=='Student'){
$qry2="INSERT INTO student( firstname, lastnamename) VALUES('$fname','$lname')";}

else
{ $qry2 = "INSERT INTO lecturer( lecturer_fname, lecturer_lname) VALUES('$fname','$lname')";
} }
$result = @mysql_query($qry);
$result2= @mysql_query($qry2);


//Check whether the query was successful or not
if($result) {
if($result2)
header("location: register-success.php");
exit();
}else {
die("Query failed");
}


why can't it insert the data into the student table???