Changeset 12375


Ignore:
Timestamp:
2007/05/09 15:14:53 (17 years ago)
Author:
matsumoto
Message:
 
File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/dev/data/class/SC_CustomerList.php

    r12374 r12375  
    222222            $val = $this->arrSql['domain']; 
    223223            if($val==3){ 
    224                     if(DB_TYPE == "pgsql"){ 
    225                 $this->setWhere( "(email || email_mobile LIKE ?)" ); 
    226             }elseif(DB_TYPE == "mysql"){ 
    227                 $this->setWhere("concat(email,email_mobile) LIKE ?" ); 
    228             } 
    229             $sql_where .= "dtb_customer.email_mobile LIKE ? "; 
    230             $this->setWhere($sql_where); 
    231             $searchDomainType = $this->addSearchStr("@docomo.ne.jp"); 
    232             print($searchDomainType); 
    233             } 
     224                    $sql = "SELECT email_mobile FROM dtb_customer WHERE email_mobile LIKE '%@docomo.ne.jp'"; 
     225            } 
     226            $this->arrVal[] = $sql; 
    234227        } 
    235228         
    236 //print_r($this->arrSql); 
     229         
     230print_r($this->arrSql); 
     231print_r($this->arrVal); 
    237232         
    238233        //¡¡HTML-mail¡ÊÇÛ¿®Êý¼°) 
Note: See TracChangeset for help on using the changeset viewer.