if (mysqli_num_rows($result) > 0) {
    // output data of each row
    while($row = mysqli_fetch_assoc($result)) {
        if($row["Dept_Code"]==$myusername && $row["password"]==$mypassword)
        {
            $check=1;
            $_SESSION["dept"] = $myusername;
             header('Location: http://co-project.lboro.ac.uk/crew01/Test2.php');
        }
    }
} else {
    echo "0 results";
}
$_SESSION["successLogin"] = $check; //store result in session variable
if ($check=0)
    {header("location:error.php");}