orderlist.php 의 쿼리문 질문

orderlist.php 의 쿼리문 질문

QA

orderlist.php 의 쿼리문 질문

본문

adm/orderlist.php입니다



<tbody>
<?php
for ($i=0; $row=sql_fetch_array($result); $i++)
{
    // 결제 수단
    $s_receipt_way = $s_br = "";
    if ($row['od_settle_case'])
    {
        $s_receipt_way = check_pay_name_replace($row['od_settle_case'], $row);
        $s_br = '<br />';
    }
    else
    {
        $s_receipt_way = '결제수단없음';
        $s_br = '<br />';
    }

    if ($row['od_receipt_point'] > 0)
        $s_receipt_way .= $s_br."포인트";

    $mb_nick = get_sideview($row['mb_id'], get_text($row['od_name']), $row['od_email'], '');

    $od_cnt = 0;
    if ($row['mb_id'])
    {
        $sql2 = " select count(*) as cnt from {$g5['g5_shop_order_table']} where mb_id = '{$row['mb_id']}' ";
        $row2 = sql_fetch($sql2);
        $od_cnt = $row2['cnt'];
    }

    // 주문 번호에 device 표시
    $od_mobile = '';
    if($row['od_mobile'])
        $od_mobile = '(M)';

    // 주문번호에 - 추가
    switch(strlen($row['od_id'])) {
        case 16:
            $disp_od_id = substr($row['od_id'],0,8).'-'.substr($row['od_id'],8);
            break;
        default:
            $disp_od_id = substr($row['od_id'],0,6).'-'.substr($row['od_id'],6);
            break;
    }

    // 주문 번호에 에스크로 표시
    $od_paytype = '';
    if($row['od_test'])
        $od_paytype .= '<span class="list_test">테스트</span>';

    if($default['de_escrow_use'] && $row['od_escrow'])
        $od_paytype .= '<span class="list_escrow">에스크로</span>';

    $uid = md5($row['od_id'].$row['od_time'].$row['od_ip']);

    $invoice_time = is_null_time($row['od_invoice_time']) ? G5_TIME_YMDHIS : $row['od_invoice_time'];
    $delivery_company = $row['od_delivery_company'] ? $row['od_delivery_company'] : $default['de_delivery_company'];

    $bg = 'bg'.($i%2);
    $td_color = 0;
    if($row['od_cancel_price'] > 0) {
        $bg .= 'cancel';
        $td_color = 1;
    }
?>
<tr class="orderlist<?php echo ' '.$bg; ?>">
    <td rowspan="3" class="td_chk">
        <input type="hidden" name="od_id[<?php echo $i ?>]" value="<?php echo $row['od_id'] ?>" id="od_id_<?php echo $i ?>">
        <label for="chk_<?php echo $i; ?>" class="sound_only">주문번호 <?php echo $row['od_id']; ?></label>
        <input type="checkbox" name="chk[]" value="<?php echo $i ?>" id="chk_<?php echo $i ?>">
    </td>
    <td headers="th_ordnum" class="td_odrnum2" rowspan="2" colspan="2">
        <a href="<?php echo G5_SHOP_URL; ?>/orderinquiryview.php?od_id=<?php echo $row['od_id']; ?>&uid=<?php echo $uid; ?>" class="orderitem"><?php echo $disp_od_id; ?></a>
        <?php echo $od_mobile; ?>
        <?php echo $od_paytype; ?>
    </td>
    <td headers="mb_3" rowspan="2"><?php
        $sql3 = " select a.od_id , a.mb_id, a.od_name, a.od_tel, a.od_hp, a.od_b_name, a.od_b_tel, a.od_b_hp, a.od_deposit_name, a.od_invoice, b.mb_3, b.mb_4
        from {$g5['g5_shop_order_table']} a, {$g5['group_member_table']} b
        where mb_id = '{$row['mb_id']}'
        group by od_id";
        $row3 = sql_fetch($sql3);
        var_dump($row3);?>
       </td>
    <td headers="th_odrer" class="td_name"><?php echo $mb_nick; ?></td>
    <td headers="th_odrertel" class="td_tel"><?php echo get_text($row['od_tel']); ?></td>
    <td headers="th_recvr" class="td_name"><a href="<?php echo $_SERVER['SCRIPT_NAME']; ?>?sort1=<?php echo $sort1; ?>&sort2=<?php echo $sort2; ?>&sel_field=od_b_name&search=<?php echo get_text($row['od_b_name']); ?>"><?php echo get_text($row['od_b_name']); ?></a></td>
    <td rowspan="3" class="td_num td_numsum"><?php echo number_format($row['od_cart_price'] + $row['od_send_cost'] + $row['od_send_cost2']); ?></td>

 

$sql3 에 멤버 테이블의 여분필드인 mb_3와 mb_4 를  가지고 오고 싶은데 어떻게 해야 될지 모르겟네요 ㅠㅠ 

이 질문에 댓글 쓰기 :

답변 2


$sql3 = " select a.od_id , a.mb_id, a.od_name, a.od_tel, a.od_hp, a.od_b_name, a.od_b_tel, a.od_b_hp, a.od_deposit_name, a.od_invoice, b.mb_3, b.mb_4
        from {$g5['g5_shop_order_table']} a, {$g5['group_member_table']} b
        where mb_id = '{$row['mb_id']}'
        group by od_id";

->

$sql3 = " select a.od_id , a.mb_id, a.od_name, a.od_tel, a.od_hp, a.od_b_name, a.od_b_tel, a.od_b_hp, a.od_deposit_name, a.od_invoice, b.mb_3, b.mb_4
        from {$g5['g5_shop_order_table']} a inner join {$g5['member_table']} b on a.mb_id = b.mb_id
        where a.mb_id = '{$row['mb_id']}'
        group by a.od_id";

<?php echo echo $row['mb_3'];?>

<?php echo echo $row['mb_4'];?>

 

이런식으로 출력하시면 됩니다

답변을 작성하시기 전에 로그인 해주세요.
전체 43
QA 내용 검색

회원로그인

(주)에스아이알소프트 / 대표:홍석명 / (06211) 서울특별시 강남구 역삼동 707-34 한신인터밸리24 서관 1404호 / E-Mail: admin@sir.kr
사업자등록번호: 217-81-36347 / 통신판매업신고번호:2014-서울강남-02098호 / 개인정보보호책임자:김민섭(minsup@sir.kr)
© SIRSOFT