"; $edit_link=""; $delete_link=""; $sql_check_child=" SELECT count(*) FROM tbl_categories WHERE cat_id not IN (SELECT parent_id FROM tbl_categories) and cat_id='".$cat_id_val."'"; $res_check_child=@mysqli_query($conn,$sql_check_child); $check_child_row = mysqli_fetch_array($res_check_child); $num=$check_child_row[0]; if($num>0) { $delete_link=" "; } $data['rows'][] = array( 'id' => $row['id'], 'cell' => array($count++, $cat_id_val, $row['cat_name'],$row['remarks'], $view_link, $edit_link, $delete_link,) ); } echo json_encode($data); ?>