Changeset 12025
- Timestamp:
- 2007/03/29 14:32:31 (17 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/dev/html/admin/total/index.php
r12024 r12025 624 624 $sql.= "(price * sum(quantity)) AS total "; 625 625 $sql.= "FROM dtb_order_detail WHERE order_id IN (SELECT order_id FROM dtb_order WHERE $where ) "; 626 $sql.= "GROUP BY product_id, product_ code, price ";626 $sql.= "GROUP BY product_id, product_name, product_code, price "; 627 627 $sql.= ") AS T1 "; 628 628 $sql.= "ORDER BY T1.total DESC ";
Note: See TracChangeset
for help on using the changeset viewer.