//get lecturer id's in the database
$get_lectId = "SELECT id FROM user WHERE type = 'lect'";
$get_lectId_res = mysql_query($get_lectId);
while ($row = mysql_fetch_array($get_lectId_res)) {
echo "<option>{$row['id']}</option>";
}
echo "</select>";
if (isset($_POST['btnadd']) && $_POST['dept'] != "SELECT DEPARTMENT") {
$add = new Lecturer();
$add->addDetails();
} elseif (isset($_POST['btnupdate'])) {
$update = new Lecturer();
$update->updateDetails();
} elseif (isset($_POST['btnupdatepass'])) {
$update = new Lecturer();
$update->updatePass();
} elseif (isset($_POST['btnget']) && $_POST['regno'] != "SELECT") {
//get lecturer details in database
$getid = $_POST['regno'];
$get_details = "SELECT name,pass,lectEmail,department FROM lecturer,user \n\t\t\t\t\t\tWHERE lectId='{$getid}' AND id='{$getid}'";
$get_details_res = mysql_query($get_details);
$getname = mysql_result($get_details_res, 0, 'name');
$getpass = mysql_result($get_details_res, 0, 'pass');
$getemail = mysql_result($get_details_res, 0, 'lectEmail');
$getdept = mysql_result($get_details_res, 0, 'department');
} elseif (isset($_POST['btndeldata']) && $_POST['regno'] != "SELECT") {
$delete = new Lecturer();
$delete->deleteDetails();
} elseif (isset($_POST['btnclrdata'])) {
//clears form data to get an empty form
header("Location:lectdata.php");
