order 테이블에 상품명 넣기

// 주문번호를 얻는다.
$od_id = get_session('ss_order_id');


$sql = " select it_name
            from {$g5['g5_shop_cart_table']}
            where od_id = '$od_id' ";
$ct = sql_fetch($sql);
$ct_name2 = get_text($ct['it_name']);


$sql = " select count(*) as cnt
            from {$g5['g5_shop_cart_table']}
            where od_id = '$od_id' ";
$ct2 = sql_fetch($sql);
if($ct2['cnt'] > 1)
    $ct_name2 .= ' 외 '.($ct2['cnt'] - 1).'건';

 

$sql = " insert {$g5['g5_shop_order_table']}

            set od_id             = '$od_id',

                od_itname         = '$ct_name2'
                ";
$result = sql_query($sql, false);