query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getAreaList = "SELECT * FROM `kra_division_child_tbl` WHERE deleted ='0' AND `child_division_id`='$SelectedRecordID' ORDER BY `kra_code` ASC";
$getKRA = mysqli_query($conn,$getAreaList);
$statRow = mysqli_num_rows($getKRA);
if($statRow > 0){
while($row = mysqli_fetch_array($getKRA)){
$count = $count + 1;
?>".$row['id']."";
echo "| ".$row['weight']." | ";
echo "".$row['kra_code']." | ";
echo "".$row['kra_name']." | ";
echo "";?>
";
echo " | ";?>
";
echo " |
| ";
echo "
";
}
if($infCanvass!='' || $infCanvass != null){
if($statRow===''){
$statRow = 0;
}
echo "
";
echo "| Record/s found: ".$statRow." | ";
echo "
";
}
}
$conn->close();
}
?>