query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
$getKRAList = "SELECT * FROM `ops_data_autohub` WHERE `deleted`=0 AND `ops_title_id` ='$opsPlanHeaderID' ORDER BY `ops_kra` ASC";
//$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)){
$count = $count + 1;
if($count >1 ){
if($border !=$row['ops_kra']){
$botBorder = '1px solid #000';
}else{
$botBorder = '1px solid lightgray';
}
}else{
$botBorder = '1px solid lightgray';
}
?>