query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `pcp_headers` WHERE `deleted`=0 AND `employee_id` ='$SelectedRecordID' ORDER BY `year` DESC";
//$getAreaList = "SELECT * FROM `pms_area_tbl` WHERE deleted ='0'";
$getKRA = mysqli_query($conn,$getKRAList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
if($row['status']==="UNPOSTED"){
$fontColor="#02470A";
}else{
$fontColor="#7B7F7B";
}
?>".$row['id']."";
echo "| ".$row['year']." | ";
echo "".$row['period']." | ";
echo "".$row['status']." | ";
echo "".$row['pcp_name']." | ";
echo "".$row['pcp_description']." | ";
echo "";?>
";
echo " | ";?>
";
echo " |
";
}
}
$conn->close();
}
?>