query("SELECT `description` FROM `prf_expenseitems` WHERE `description` LIKE '%$search%' ORDER BY `description` ASC") or die(mysqli_connect_errno()); $list = array(); $rows = $query->num_rows; if($rows > 0){ while($fetch = $query->fetch_assoc()){ $data['value'] = $fetch['description']; array_push($list, $data); } } echo json_encode($list); ?>