Changeset 2150 for temp/trunk

Timestamp:

2006/08/26 19:21:41 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/products/index.php (modified) (1 diff)

temp/trunk/html/admin/products/index.php

@@ -136 +136 @@
                     break;
                 case 'search_product_class_name': //µ¬³Ê̾¾Î
-                    $where .= " AND  product_id IN (SELECT product_id FROM dtb_products_class WHERE classcategory_id1 IN (SELECT classcategory_id FROM dtb_classcategory WHERE class_id IN (SELECT class_id FROM dtb_class WHERE name LIKE ?))) ";
+                    $where_in = " (SELECT classcategory_id FROM dtb_classcategory WHERE class_id IN (SELECT class_id FROM dtb_class WHERE name LIKE '?')) ";
+                    $where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE classcategory_id1 IN " . $where_in;
+                    $where .= " OR classcategory_id2 IN" . $where_in;
+                    $arrval[] = "%$val%";
                     $arrval[] = "%$val%";
                     break;