Changeset 12025


Ignore:
Timestamp:
2007/03/29 14:32:31 (15 years ago)
Author:
uehara
Message:
 
File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/dev/html/admin/total/index.php

    r12024 r12025  
    624624    $sql.= "(price * sum(quantity)) AS total "; 
    625625    $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 "; 
    627627    $sql.= ") AS T1 "; 
    628628    $sql.= "ORDER BY T1.total DESC "; 
Note: See TracChangeset for help on using the changeset viewer.