это я понял. но я, про этот вариант:
if (count($search)>1) for ($j=1; $j<count($search); $j++) $ss = 'AND (P.name LIKE \'%'.$search[$j].'%\' OR P.h1 LIKE \'%'.$search[$j].'%\' OR P.product_code LIKE \'%'.$search[$j].'%\' OR P.brief_description LIKE \'%'.$search[$j].'%\') ';
else $ss='';
$g_search_count=db_r('select count(*) FROM `' . PRODUCTS_TABLE . '` AS P INNER JOIN `' . CATEGORIES_TABLE . '` AS C USING(categoryID) WHERE P.enabled =1 AND C.enabled =1 and (P.name LIKE \'%'.$search[0].'%\' OR P.h1 LIKE \'%'.$search[0].'%\' OR P.product_code LIKE \'%'.$search[0].'%\' OR P.brief_description LIKE \'%'.$search[0].'%\')'.$ss);
$sql = 'SELECT P.*,B.name brand_name, B.hurl brand_hurl, count(R.reviewID) count_review FROM `' . PRODUCTS_TABLE . '` AS P LEFT JOIN `' . REVIEW_TABLE . '` as R USING(productID) LEFT JOIN `' . BRAND_TABLE . '` as B USING (brandID) INNER JOIN `' . CATEGORIES_TABLE . '` AS C ON (P.categoryID = C.categoryID) WHERE P.enabled =1 AND C.enabled =1 and (P.name LIKE \'%'.$search[0].'%\' OR P.h1 LIKE \'%'.$search[0].'%\' OR P.product_code LIKE \'%'.$search[0].'%\' OR P.brief_description LIKE \'%'.$search[0].'%\')'.$ss.' GROUP BY `P`.`productID` ORDER BY P.' . $_SESSION['sort'] . ' ' . $_SESSION['order'];