format("Y-m-d"); if(isset($_POST['done'])){ $selectedTemplate = mysql_escape_string($_POST['selectedTemplate']); mysql_query("UPDATE `cl_template_name` SET `cl_template_status` = 0 WHERE `id`='$selectedTemplate'"); $gtTempHeader = mysql_query("SELECT * FROM `cl_template_name` WHERE `cl_template_status` = 1 AND `cl_comp_id`='$compID'ORDER BY `id` ASC"); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; 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); ?>".$row['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

No.	LEVEL	DESCRIPTOIN	COVERAGE	RECOMMENDIG OFFICER #1"; echo "	RECOMMENDIG OFFICER #1"; echo "	APPROVING OFFIER"; ECHO "
"; if($row['cl_template_tag']==='CO'){ echo "COMPANY LEVEL"; }else{ echo "AUTOHUB LEVEL"; } echo"	".$row['cl_template_name']."	"; echo $row['cl_template_rank']; echo"	"; echo $rcaL .', '.$rcaF; echo"	"; echo $rcbL .', '.$rcbF; echo"	"; echo $aprL .', '.$aprF; echo"

"; echo ''; exit(); } ?>