주문내역에서 상품분류코드가 보였으면합니다 채택완료

​/adm/shop_admin/orderform.php

...............

// 상품목록
$sql = " select it_id,
                it_name,
                cp_price,
                ct_notax,
                ct_send_cost,
                it_sc_type

           from {$g5['g5_shop_cart_table']} a

          where a.od_id = '{$od['od_id']}' 

          group by a.it_id
          order by a.ct_id ";
$result = sql_query($sql);​

44번째 라인을 아래와 같이 변경

​

// 상품목록
$sql = " select a.it_id,
                a.it_name,
                a.cp_price,
                a.ct_notax,
                a.ct_send_cost,
                a.it_sc_type,
                b.ca_id,
                c.ca_name
           from {$g5['g5_shop_cart_table']} a, {$g5['g5_shop_item_table']} b, {$g5['g5_shop_category_table']} c
          where a.od_id = '{$od['od_id']}' and a.it_id = b.it_id and b.ca_id = c.ca_id
          group by a.it_id
          order by a.ct_id ";
$result = sql_query($sql);​

..............................​

​

​.......

        $chk_cnt = 0;
        for($i=0; $row=sql_fetch_array($result); $i++) {
            // 상품이미지
            $image = get_it_image($row['it_id'], 50, 50);
            $item_caid = $row['ca_id'];
            $item_caname = $row['ca_name'];​​​​

            // 상품의 옵션정보
            $sql = " select ct_id, it_id, ct_price, ct_point, ct_qty, ct_option, ct_status, cp_price, ct_stock_use, ct_point_use, ct_send_cost, io_type, io_price
                        from {$g5['g5_shop_cart_table']}
                        where od_id = '{$od['od_id']}'
                          and it_id = '{$row['it_id']}'
                        order by io_type asc, ct_id asc ";
            $res = sql_query($sql);
            $rowspan = mysql_num_rows($res);

.........

149번 라인 밑에 추가

           $item_caid = $row['ca_id'];
           $item_caname = $row['ca_name'];​​​​​ 

..........

................

위와 같이 하면 될것 같은데요....

짧은지식이나마 도움이 되셨으면 좋겠네요??

​