format("Y-m-d"); ?> "; echo ""; echo "No."; echo "LEVEL"; echo "DESCRIPTOIN"; echo "COVERAGE"; echo "RECOMMENDIG OFFICER #1"; echo "RECOMMENDIG OFFICER #1"; echo "APPROVING OFFIER"; echo "AUTHORIZING HR"; ECHO ""; while($row=mysql_fetch_array($gtTempHeader)){ $rcaF = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['cl_recommending_officer_a']."'"),0); $rcaL = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['cl_recommending_officer_a']."'"),0); $rcbF = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['cl_recommending_officer_b']."'"),0); $rcbL = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['cl_recommending_officer_b']."'"),0); $aprF = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['cl_approving_officer']."'"),0); $aprL = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['cl_approving_officer']."'"),0); $aprHRL = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['cl_hr_approval_id']."'"),0); $aprHRF = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['cl_hr_approval_id']."'"),0); ?>".$row['id'].""; echo ""; if($row['cl_template_tag']==='CO'){ echo "COMPANY LEVEL"; }else{ echo "AUTOHUB LEVEL"; } echo""; echo "".$row['cl_template_name'].""; echo ""; echo $row['cl_template_rank']; echo""; echo ""; echo $rcaL .', '.$rcaF; echo""; echo ""; echo $rcbL .', '.$rcbF; echo""; echo ""; echo $aprL .', '.$aprF; echo""; echo ""; echo $aprHRL .', '.$aprHRF; echo""; echo ""; } echo ""; echo ''; //echo "

✏ NEW RECORD HAS BEEN ADDED

"; exit(); } ?>