Changeset 10293 for temp/trunk/html

Timestamp:

2006/12/06 12:13:12 (20 years ago)

Author:

kaki

Message:

 

File:

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

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

@@ -165 +165 @@
                 case 'search_product_code': // ¾¦ÉÊ¥³¡¼¥É
                     $where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ? GROUP BY product_id)";
-                    $view_where .= " AND EXISTS (SELECT product_id FROM dtb_products_class as cls WHERE cls.product_code ILIKE ? AND prd.product_id = cls.product_id GROUP BY cls.product_id )";
+                    $view_where .= " AND EXISTS (SELECT product_id FROM dtb_products_class as cls WHERE cls.product_code ILIKE ? AND dtb_products.product_id = cls.product_id GROUP BY cls.product_id )";
                     $arrval[] = "%$val%";
                     break;