Product Search in Admin

Fix worked for me too!! Thanks fortune81

great thanks, i now fix the same problem of my worede-fashion site. and just fix the upper half code , before the "else" , below is full code after i swap it:

// fix duplicates and force search to use master_categories_id

  $products_query_raw = ("select p.products_type, p.products_id, pd.products_name, p.products_quantity,
                                   p.products_image, p.products_price, p.products_date_added,
                                   p.products_last_modified, p.products_date_available,
                                   p.products_status, p2c.categories_id,
                                   p.products_model,
                                   p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute,
                                   p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping,
                                   p.products_quantity_order_max, p.products_sort_order
                            from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, "
                                   . TABLE_PRODUCTS_TO_CATEGORIES . " p2c
                            where p.products_id = pd.products_id
                            and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                            and p.products_id = p2c.products_id
                            and (
                            pd.products_name like '%" . zen_db_input($_GET['search']) . "%'
                            or pd.products_description like '%" . zen_db_input($_GET['search']) . "%'
                            or p.products_model like '%" . zen_db_input($_GET['search']) . "%')" .
                            $order_by);

/* $products_query_raw = ("select p.products_type, p.products_id, pd.products_name, p.products_quantity,
p.products_image, p.products_price, p.products_date_added,
p.products_last_modified, p.products_date_available,
p.products_status, p2c.categories_id,
p.products_model,
p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute,
p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping,
p.products_quantity_order_max, p.products_sort_order,
p.master_categories_id
from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, "
. TABLE_PRODUCTS_TO_CATEGORIES . " p2c
where p.products_id = pd.products_id
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
and (p.products_id = p2c.products_id
and p.master_categories_id = p2c.categories_id)
and (
pd.products_name like '%" . zen_db_input($_GET['search']) . "%'
or pd.products_description like '%" . zen_db_input($_GET['search']) . "%'
or p.products_id = '" . zen_db_input($_GET['search']) . "'
or p.products_model like '%" . zen_db_input($_GET['search']) . "%')" .
$order_by);
*/

} else {
  $products_query_raw = ("select p.products_type, p.products_id, pd.products_name, p.products_quantity,
                                   p.products_image, p.products_price, p.products_date_added,
                                   p.products_last_modified, p.products_date_available,
                                   p.products_status, p.products_model,
                                   p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute,
                                   p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping,
                                   p.products_quantity_order_max, p.products_sort_order
                            from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c
                            where p.products_id = pd.products_id
                            and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                            and p.products_id = p2c.products_id
                            and p2c.categories_id = '" . (int)$current_category_id . "'" .
                            $order_by);
}

// Split Page