Changeset 220 for branches/dev/html


Ignore:
Timestamp:
2007/02/09 13:13:08 (19 years ago)
Author:
inoue
Message:

商品番号検索の修正

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/dev/html/admin/products/product_select.php

    r17 r220  
    6363            case 'search_product_code': 
    6464                $where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ? GROUP BY product_id)"; 
    65                 $where .= " OR product_code ILIKE ?"; 
    66                 $arrval[] = "%$val%"; 
    67                 $arrval[] = "%$val%"; 
     65                $arrval[] = "$val%"; 
    6866                break; 
    6967            default: 
Note: See TracChangeset for help on using the changeset viewer.