Changeset 2148 for temp


Ignore:
Timestamp:
2006/08/26 19:14:41 (20 years ago)
Author:
kakinaka
Message:

blank

Location:
temp/trunk
Files:
2 edited

Legend:

Unmodified
Added
Removed

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

    r2147 r2148  
    137137                case 'search_product_class_id': //µ¬³Ê̾¾Î 
    138138                    //$where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_class_id = ?)"; 
    139                     $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 %?%))) "; 
    140                     $arrval[] = $val; 
     139                    $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 ?))) "; 
     140                    $arrval[] = "%$val%"; 
    141141                    break; 
    142142                case 'search_name':         // ¾¦ÉÊ̾ 
Note: See TracChangeset for help on using the changeset viewer.