Changeset 4721 for temp/trunk/html/admin/home.php

Timestamp:

2006/09/14 14:33:42 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/home.php (modified) (1 diff)

temp/trunk/html/admin/home.php

@@ -85 +85 @@
     if ( $method == 'SUM' or $method == 'COUNT'){
         $sql = "SELECT ".$method."(total) FROM dtb_order
-                 WHERE del_flg = 0 AND cast(substring(create_date,1,6) as date) = ? 
+                 WHERE del_flg = 0 AND cast(substring(create_date,1,7) as date) = ? 
                  AND cast(substring(create_date,1, 10) as date) <> cast(substring(now(),1, 10) as date)";
         $return = $conn->getOne($sql, array($month));