<?php
include_once("../../../cfg/conn.php"); 
$sql ="SELECT * FROM kra_comp_detl WHERE deleted=0 ORDER BY kra_name ASC";
$count =0;
header("Content-Type: application/xls");    
header("Content-Disposition: attachment; filename=rptAreaList.csv");  
header("Pragma: no-cache"); 
header("Expires: 0");


 
//make the column headers what you want in whatever order you want
echo 'NO, MAIN KRA,KRA CODE,KRA NAME, DESCRIPTION'."\n";
//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']."\n";
    }
        
}
 
?>