';
//make the column headers what you want in whatever order you want
echo '
| NO |
MAIN KRA |
KRA CODE |
KRA NAME |
KRA DESCRIPTION |
';
//loop the query data to the table in same order as the headers
$getArea = mysqli_query($conn,$sql);
$statRow = mysqli_num_rows($getArea);
if($statRow > 0){
while($row = mysqli_fetch_array($getArea)){
$count = $count + 1;
echo "| ".$count." |
".$row['grp_kra_id']." |
".$row['kra_code']." |
".$row['kra_name']." |
".$row['kra_description']." |
";
}
}
echo '';
?>