".$fCount.". ".$row['cl_div_name']." ";
$gtUNITTemplate = mysql_query("SELECT * FROM `cl_approving_unit` WHERE `cl_div_id`='$divID' ORDER BY `cl_order` ASC");
while($dRow=mysql_fetch_array($gtUNITTemplate)){
$unitID = $dRow['id'];
echo "
";
?>
".$unitID ."";
echo "
- " .strtoupper($dRow['cl_unit_name'])."
";
echo "
";
$oldSLAa = mysql_result(mysql_query("SELECT `cl_sla_a` FROM `cl_approving_officers` WHERE `cl_div_id`='$divID' AND `cl_unit_id`='$unitID' AND `cl_level`='$rank' AND `cl_comp_id`='$compID'"),0);
echo $oldSLAa. " Days";
echo"
";
echo "
";
echo "
";
echo "
";
$oldSLAb = mysql_result(mysql_query("SELECT `cl_sla_b` FROM `cl_approving_officers` WHERE `cl_div_id`='$divID' AND `cl_unit_id`='$unitID' AND `cl_level`='$rank' AND `cl_comp_id`='$compID'"),0);
echo $oldSLAb. " Days";
echo"
";
echo "
";
echo "
";
echo "
";
echo "
";
}
echo"
";
echo "
";
}
echo "
";
echo "
☸ HEAD OFFICE CLEARANCE
";
$gtHOTemplate = mysql_query("SELECT * FROM `cl_approving_division` WHERE `cl_div_tag`='HO' ORDER BY `cl_div_order` ASC");
echo "
".$fCountHo.". ".$hRow['cl_div_name']." ";
$gtUNITTemplateHO = mysql_query("SELECT * FROM `cl_approving_unit` WHERE `cl_div_id`='$divIDHO' ORDER BY `cl_order` ASC");
while($hoRow=mysql_fetch_array($gtUNITTemplateHO)){
$unitIDHO = $hoRow['id'];
echo "
";
?>
".$unitIDHO ."";
echo "
- " .strtoupper($hoRow['cl_unit_name'])."
";
echo "
";
$oldSLAa = mysql_result(mysql_query("SELECT `cl_sla_a` FROM `cl_approving_officers` WHERE `cl_div_id`='$divIDHO' AND `cl_unit_id`='$unitIDHO' AND `cl_level`='$rank' AND `cl_comp_id`='$compID'"),0);
echo $oldSLAa. " Days";
echo"
";
echo "
";
echo "
";
echo "
";
$oldSLAb = mysql_result(mysql_query("SELECT `cl_sla_b` FROM `cl_approving_officers` WHERE `cl_div_id`='$divIDHO' AND `cl_unit_id`='$unitIDHO' AND `cl_level`='$rank' AND `cl_comp_id`='$compID'"),0);
echo $oldSLAb. " Days";
echo"
