EMP.ID PCP ID YEAR PERIOD PCP STATUS EMPLOYEE NAME MAR SETUP STAT PEF ".$activeRecordID.""; echo "".$row['id'].""; echo "".$row['year'].""; echo "".$row['period'].""; echo "".$row['status'].""; echo ""; echo getEmployeeEmpInformationB($activeRecordID)[3]. " ".getEmployeeEmpInformationB($activeRecordID)[2]; echo ""; echo ""; $countMAR = "SELECT * FROM `mar_emp_header` WHERE `pcp_id`='$activePCPid' AND `emp_id`='$employeeID'"; $result = mysqli_query($conn,$countMAR); $marC = mysqli_num_rows($result); if($marC > 0){ while($w=mysqli_fetch_array($result)){ $mCount=$mCount + 1; } }else{ $mCount = 0; } echo $mCount." / ".$periodCount; // found in pcp_header table $mCount =0; echo ""; echo ""; ?>"; echo ""; if($row['status']==="APPROVED"){ echo ""; }else{ echo ""; } echo ""; echo ""; ?> "; echo ""; } } if($count ==0){ echo ""; echo "
No pending PEF for approval"; echo ""; } $conn->close(); } ?>