0){ while($row = mysqli_fetch_array($getKRA)){ $count = $count + 1; if($row['status']==="OPEN"){ $fontColor="#02470A"; }else{ $fontColor="#7B7F7B"; } ?>".$row['id'].""; echo "".$row['year'].""; echo "".$row['period'].""; echo "".$row['status'].""; echo "".$row['pcp_name'].""; echo ""; $countMAR = "SELECT * FROM `mar_emp_header` WHERE `pcp_id`='1' AND `emp_id`='1'"; $result = mysqli_query($conn,$countMAR); while($w=mysqli_fetch_array($result)){ $mCount=$mCount +1; } echo $mCount . "/6"; echo ""; echo ""; if($row['pef_rating']!=''){ echo ""; }else{ echo ""; } echo ""; echo ""; if($row['status']==="OPEN"){ echo ""; }else{ echo ""; } echo ""; echo "";?> "; } echo ""; } $conn->close(); } ?>