$h_fail = "Unit: " . $ut_id . " Not Added";
    database($sql, $h_success, $h_fail);
}
//---------------------------------------------- Add Billing Plan ---------------------------------------------------------------------------
function add_plan($bill_plan, $name, $years, $roi)
{
    $sql = "INSERT INTO bill_plan (bill_plan, name, no_years, roi, cr_dt)\nVALUES ('{$bill_plan}', '{$name}', '{$years}', '{$roi}', now());";
    $h_success = "Billing Plan: " . $desc . " Added Successfully";
    $h_success = "<script type='text/javascript'>alert('{$h_success}');</script>";
    $h_fail = "Billing Plan: " . $bill_plan . " Not Added";
    database($sql, $h_success, $h_fail);
}
switch ($_POST[add]) {
    case "tower":
        unset($msg);
        add_tower($_POST['tw_id'], $_POST['desc']);
        break;
        //add tower
    //add tower
    case "type":
        unset($msg);
        add_type($_POST[type_id], $_POST[desc], $_POST[tw_id], $_POST[price]);
        break;
        //add type
    //add type
    case "unit":
        unset($msg);
        add_unit($_POST[ut_id], $_POST[type], $_POST[tw_id], $_POST[floor], $_POST[area]);
        break;
        //add unit
    //add unit
    $h_success = "Type " . $desc . " Added Successfully";
    $h_fail = "Location:reg_fail.php";
    database($sql, $h_success, $h_fail);
}
//---------------------------------------------- Add Unit -------------------------------------------------------------------------------
function add_unit($ut_id, $type, $tw_id, $floor, $area)
{
    $sql = "INSERT INTO unit (ut_id, type, tw_id, floor, area, cr_dt)\nVALUES ('{$ut_id}', '{$type}', '{$tw_id}', '{$floor}', '{$area}', now());";
    $h_success = "Unit " . $ut_id . " Added Successfully";
    $h_fail = "Location:reg_fail.php";
    database($sql, $h_success, $h_fail);
}
switch ($_POST[action]) {
    case "add_tower":
        unset($msg);
        add_tower($_POST[tw_id], $_POST[desc]);
        break;
        //add tower
    //add tower
    case "add_type":
        unset($msg);
        add_type($_POST[type_id], $_POST[desc], $_POST[tw_id], $_POST[price]);
        break;
        //add type
    //add type
    case "add_unit":
        unset($msg);
        add_unit($_POST[ut_id], $_POST[type], $_POST[tw_id], $_POST[floor], $_POST[area]);
        break;
        //add unit
        //case "disp_unit"  : unset($msg); disp_unit(); break; //display unit