";
echo "| " . $count . " | ";
echo "" . STRTOUPPER($title) . " | ";
echo "".STRTOUPPER($row['emp_name'])." | ";
echo "" . STRTOUPPER($row['date_access']) . " | ";
echo "";
$chkOpenExamTaken = mysql_result(mysql_query("SELECT COUNT('id') FROM `pod_exam_true_false_answer` WHERE `training_id`='$trID' AND `status`='1' AND `chk_required`='YES' AND `employee_id`='$empID' AND `verified`='NO'"),0);
echo "".number_format($chkOpenExamTaken,0,'.',',')."";
echo " | ";
echo "";
$totalExamScores = mysql_result(mysql_query("SELECT SUM(`total_points`) FROM `pod_exam_contents` WHERE `training_id`='$trID'"),0);
$scores = mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `training_id`='$trID' AND `employee_id`='".$row['employee_id']."' AND `ex_type`='POST'"),0);
$myScores = $scores / $totalExamScores * 100;
if($myScore < 75){
$txtColore = 'red';
}else{
$txtColore = 'blue';
}
echo "".number_format($myScores,2,'.',',')." %";
echo " | ";
echo "
| ";
echo "
";
}
echo "