Changeset 4845 for temp/trunk/html/admin/total

Timestamp:

2006/09/17 13:27:11 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/total/index.php (modified) (2 diffs)

temp/trunk/html/admin/total/index.php

@@ -542 +542 @@
     
     // ²ñ°÷½¸·×¤Î¼èÆÀ
-    $col = "COUNT(*) AS order_count, SUM(total) AS total, int8(AVG(total)) AS total_average, order_sex";
+    $col = "COUNT(*) AS order_count, SUM(total) AS total, (AVG(total)) AS total_average, order_sex";
     $from = "dtb_order";
     $objQuery = new SC_Query();
@@ -687 +687 @@
         $tmp_col.= "sum(men_member) as men_member, sum(men_nonmember) as men_nonmember,";
         $tmp_col.= "sum(women_member) as women_member, sum(women_nonmember) as women_nonmember,";
-        $tmp_col.= "sum(total) as total, int8(avg(total_average)) as total_average";
+        $tmp_col.= "sum(total) as total, (avg(total_average)) as total_average";
         $objQuery = new SC_Query();