주문금액과 주문자 정보(쇼핑에 관련된)

$sql  = " select a.*, "._MISU_QUERY_." 
          from $g4[yc4_order_table] a 
                left join $g4[yc4_cart_table] b on (a.on_uid=b.on_uid) 
          where a.mb_id = '$member[mb_id]' 
          group by a.od_id  "; 
$result = sql_query($sql); 

$tot_itemcnt      = 0; 
$tot_orderamount  = 0; 
$tot_ordercancel  = 0; 
$tot_dc_amount    = 0; 
$tot_receiptamount = 0; 
$tot_receiptcancel = 0; 
$tot_misuamount    = 0; 
for ($i=0; $row=mysql_fetch_array($result); $i++) 
{ 
    $tot_itemcount    += $row[itemcount]; 
    $tot_orderamount  += $row[orderamount]; 
    $tot_ordercancel  += $row[ordercancel]; 
    $tot_dc_amount    += $row[od_dc_amount]; 
    $tot_receiptamount += $row[receiptamount]; 
    $tot_receiptcancel += $row[receiptcancel]; 
    $tot_misu          += $row[misu]; 
}