Changeset 374


Ignore:
Timestamp:
2007/02/26 18:28:42 (15 years ago)
Author:
inoue
Message:

フォーラム通りに対応

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/dev/html/admin/home.php

    r330 r374  
    107107    }else if (DB_TYPE == "mysql") { 
    108108        $sql = "SELECT ".$method."(total) FROM dtb_order 
    109                  WHERE del_flg = 0 AND cast(substring(create_date,1,7) as date) = ?  
     109                 WHERE del_flg = 0 AND date_format(create_date, '%Y/%m') = ?  
    110110                 AND cast(substring(create_date,1, 10) as date) <> cast(substring(now(),1, 10) as date)"; 
    111111    } 
Note: See TracChangeset for help on using the changeset viewer.