Change in search query

[♥mdtaylorlrim]

In the /admin/categories.php the search box only searches off of the product description field. I would like to search off of the actual item id, so i changed it to:

 

$products_query = tep_db_query("select p.products_model, 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 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)$languages_id . "' and p.products_id = p2c.products_id and pd.products_id = '" . tep_db_input($search) . "' order by pd.products_id");

 

But yes, I want to have my cake and eat it too. I want it to search of of either: product_id, product_name, products_model, or vendors_product_id

 

Anyone care to venture the code for that? I'm not sure of the OR statements and the () required.

 

 

Thanks

[ozEworks]

look at http://addons.oscommerce.com/info/1648

 

but vendors_product_id is not a standard field

[♥mdtaylorlrim]

look at http://addons.oscommerce.com/info/1648

 

but vendors_product_id is not a standard field

Thats, that was a shove in the right direction. And you will find I am anything but standard....