query($dSql) === TRUE){ //echo "New record created successfully"; }else{ //echo "Error: " . $sql . "
" . $conn->error; } //RELOAD EMPLOYEE KRA LIST $getKRAList = "SELECT * FROM `kra_employee_tbl` WHERE `deleted`=0 AND `emp_id` ='$empRecordID' ORDER BY `kra_code` 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)){ ?>".$row['id'].""; echo "".$row['weight'].""; echo "".$row['kra_code'].""; echo "".$row['kra_name'].""; echo "";?> "; echo "";?> "; echo " "; echo ""; } } $conn->close(); } ?>