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'];?>
이런식으로 출력하시면 됩니다
답변을 작성하시기 전에 로그인 해주세요.