query($sql); $output = array('data' => array()); if($result->num_rows > 0) { // $row = $result->fetch_array(); $activeCategories = ""; while($row = $result->fetch_array()) { $categoriesId = $row[0]; // active if($row[2] == 1) { // activate member $activeCategories = ""; } else { // deactivate member $activeCategories = ""; } $button = '
'; $output['data'][] = array( $row[1], $activeCategories, $button ); } // /while }// if num_rows $connect->close(); echo json_encode($output);