query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getAreaList = "SELECT * FROM `kpi_brand` WHERE deleted =0 AND `kra_id`='$groupKRAid' ORDER BY id ASC ";
$getKRA = mysqli_query($conn,$getAreaList);
while($row = mysqli_fetch_array($getKRA)){
$target = (int)$row['kpi_target'];
if (preg_match('/%/', $target)) {
$myKPITarget = $row['kpi_target'];
}else{
$myKPITarget = number_format($target,0,'.',',');
}
?>".$row['id']."";
echo "| ".$row['kpi_weight']." | ";
echo "".$myKPITarget." | ";
echo "".$row['kpi_name']." | ";
echo "";?>
";
echo " |
| ";
echo "
";
}
$conn->close();
}
?>