Changeset 17515


Ignore:
Timestamp:
2008/08/08 15:32:36 (13 years ago)
Author:
nakanishi
Message:

#285 電話番号項目のwhere部分と検索の値設定を修正 (Yammy様)

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2/data/class/pages/admin/order/LC_Page_Admin_Order.php

    r17228 r17515  
    186186                    case 'search_order_tel': 
    187187                        if(DB_TYPE == "pgsql"){ 
    188                             $where .= " AND (order_tel01||order_tel02||order_tel03) ILIKE ?"; 
     188                            $where .= " AND (order_tel01 || order_tel02 || order_tel03) LIKE ?"; 
    189189                        }elseif(DB_TYPE == "mysql"){ 
    190                             $where .= " AND concat(order_tel01,order_tel02,order_tel03) ILIKE ?"; 
     190                            $where .= " AND concat(order_tel01,order_tel02,order_tel03) LIKE ?"; 
    191191                        } 
    192192                        $nonmark_val = ereg_replace("[()-]+","",$val); 
    193                         $arrval[] = "$nonmark_val%"; 
     193                        $arrval[] = "%$nonmark_val%"; 
    194194                        break; 
    195195                    case 'search_order_email': 
Note: See TracChangeset for help on using the changeset viewer.