Changeset 4845 for temp/trunk/html/admin/total
- Timestamp:
- 2006/09/17 13:27:11 (20 years ago)
- File:
-
- 1 edited
-
temp/trunk/html/admin/total/index.php (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
temp/trunk/html/admin/total/index.php
r4844 r4845 542 542 543 543 // ²ñ°÷½¸·×¤Î¼èÆÀ 544 $col = "COUNT(*) AS order_count, SUM(total) AS total, int8(AVG(total)) AS total_average, order_sex";544 $col = "COUNT(*) AS order_count, SUM(total) AS total, (AVG(total)) AS total_average, order_sex"; 545 545 $from = "dtb_order"; 546 546 $objQuery = new SC_Query(); … … 687 687 $tmp_col.= "sum(men_member) as men_member, sum(men_nonmember) as men_nonmember,"; 688 688 $tmp_col.= "sum(women_member) as women_member, sum(women_nonmember) as women_nonmember,"; 689 $tmp_col.= "sum(total) as total, int8(avg(total_average)) as total_average";689 $tmp_col.= "sum(total) as total, (avg(total_average)) as total_average"; 690 690 $objQuery = new SC_Query(); 691 691
Note: See TracChangeset
for help on using the changeset viewer.
