<?php

function getYear() {

    for($year = 1960; $year<2100; $year++){

        echo '<option value = "'.$year.'">'.$year.'</option>';

    }

}



function getCadre() {

    $sql = "SELECT * FROM  tblcadre";

    $result = mysql_query($sql);

    while($row = mysql_fetch_array($result)) {

        $cadreid = $row['cadreid'];

        $name = $row['name'];

        echo '<option value = "'.$cadreid.'">'.$name.'</option>';

    }

}



function getComplex() {

    $sql = "SELECT * FROM  tblcomplex";

    $result = mysql_query($sql);

    while($row = mysql_fetch_array($result)) {

        $complexid = $row['complexid'];

        $name = $row['name'];

        echo '<option value = "'.$complexid.'">'.$name.'</option>';

    }

}



function getFaculty() {

    $sql = "SELECT * FROM  tblfaculty";

    $result = mysql_query($sql);

    while($row = mysql_fetch_array($result)) {

        $facultyid = $row['facultyid'];

        $name = $row['name'];

        echo '<option value = "'.$facultyid.'">'.$name.'</option>';

    }

}



function getDepartment() {

    $sql = "SELECT * FROM tbldepartment JOIN tblfaculty ON ";

    $result = mysql_query($sql);

    while($row = mysql_fetch_array($result)) {

        $departmentid = $row['departmentid'];

        $name = $row['name'];

        echo '<option value = "'.$departmentid.'">'.$name.'</option>';

    }

}



function getUnit() {

    $sql = "SELECT * FROM tblunits";

    $result = mysql_query($sql);

    while($row = mysql_fetch_array($result)) {

        $unitid = $row['unitid'];

        $unitname = $row['unitname'];

        echo '<option value = "'.$unitid.'">'.$unitname.'</option>';

    }

}





function getReason() {

    $sql = "SELECT * FROM tblnotqualifiedreason";

    $result = mysql_query($sql);

    while($row = mysql_fetch_array($result)) {

        $reasonid = $row['reasonid'];

        $reasondesc = $row['reasondesc'];

        echo '<option value = "'.$reasonid.'">'.$reasondesc.'</option>';

    }

}



?>