escape(trim($_POST['search_item'])); $search_query = "SELECT id, name, code FROM source_dealer WHERE (code LIKE '%$search_item%' OR name LIKE '%$search_item%') AND id != 0 AND status = 1 ORDER BY name ASC"; //echo $search_query; return; $result = $db->sql_query($search_query); //echo $search_query; return; while($row = $result->fetch_assoc()) { echo ''; } // if($check_if_okay > 0){ // $remove_query = "UPDATE source_company_dealer SET status = 0 WHERE dealer_id='$dealer_id' AND company_id='$company_id'"; // $db->sql_query($remove_query); // $arr_status['status'] = 1; //done removing // echo json_encode($arr_status); // } else { // $arr_status['status'] = 0; //record not found // echo json_encode($arr_status); // } // while($row = $company_info->fetch_assoc()) { // echo ''; // } ?>