테스트 사이트 - 개발 중인 베타 버전입니다

주문내역 쿼리 질문드립니다 ㅠ 채택완료

lacomparte 8년 전 조회 4,299

주문내역이

기본은

주문번호와 일시 금액 상태 정도만 출력을하는데..

 

상품 이미지, 상품명, 옵션명도 출력해야해서 

cart table 에서 od_id 가 맞는걸 갖고와서 출력시켜줬습니다

출력은 다 되는데..

 

만약 한번에 주문으로 2개이상의 물건을 사게 될 경우;

제가 쿼리를 잘못 짜서 그런지.. 2번째 상품은 옵션이 출력이 안되어버리네요

 

 

소스와 링크 그리고 아이디 비밀번호를 적어 두겠습니다 ㅠ

힌트라도 주신다면..감사하겠습니다 ㅠ

사이트 들어가서 로그인해서 주문내역 보시면

주문내역 아래

1~8까지 숫자로 구성된 테이블이 있는데..

만약 주문번호1개에 2개 이상의 상품이 있다면

숫자로 구성된 테이블처럼 출력이 되야 해서요 ㅠㅠ

 

for문 전 쿼리에서 order_table의 od_id와 cart_table의 od_id 가 같은

자료만 갖고와서

for문 안에서 어떤 쿼리를 날려줘야 하는지 ㅠㅠ

 

 

링크

http://121.164.172.240:88/shop/">http://121.164.172.240:88/shop/ 

 

아이디

farmsismall

 

비번

1234

 

</p><p><?php</p><p>if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가</p><p> </p><p>if (!defined("_ORDERINQUIRY_")) exit; // 개별 페이지 접근 불가</p><p> </p><p>// 테마에 orderinquiry.sub.php 있으면 include</p><p>if(defined('G5_THEME_SHOP_PATH')) {</p><p>    $theme_inquiry_file = G5_THEME_SHOP_PATH.'/orderinquiry.sub.php';</p><p>    if(is_file($theme_inquiry_file)) {</p><p>        include_once($theme_inquiry_file);</p><p>        return;</p><p>        unset($theme_inquiry_file);</p><p>    }</p><p>}</p><p>$s_cart_id = get_session('ss_cart_id');</p><p>set_cart_id($sw_direct);</p><p> </p><p>// 선택필드 초기화</p><p>$sql = " UPDATE {$g5['g5_shop_cart_table']} SET ct_select = '0' WHERE od_id = '$s_cart_id' ";</p><p>sql_query($sql);</p><p> </p><p>// 주문내역 삭제</p><p>$orderinquiry_del_url = G5_SHOP_URL.'/orderinquiry.sub.del.php';</p><p> </p><p>?></p><p> </p><p><!-- 회원정보 개요 시작 { --></p><p><section id="smb_my_ov"></p><p><span class="Apple-tab-span" style="white-space:pre">	</span><h2>마이페이지 개요</h2></p><p><span class="Apple-tab-span" style="white-space:pre">	</span><table></p><p><span class="Apple-tab-span" style="white-space:pre">		</span><caption class="sound_only">마이페이지 하부 메뉴</caption></p><p><span class="Apple-tab-span" style="white-space:pre">		</span><thead></p><p><span class="Apple-tab-span" style="white-space:pre">			</span><tr></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><th>상품 관리</th></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><th>구매 관리</th></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><th>활동 관리</th></p><p><span class="Apple-tab-span" style="white-space:pre">			</span></tr></p><p><span class="Apple-tab-span" style="white-space:pre">		</span></thead></p><p><span class="Apple-tab-span" style="white-space:pre">		</span><tbody></p><p><span class="Apple-tab-span" style="white-space:pre">			</span><tr></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td><a href="<?php echo G5_SHOP_URL ?>/wishlist.php" title="관심 상품">관심 상품</a></td></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td><a href="<?php echo G5_SHOP_URL ?>/orderinquiry.php" title="주문 내역">주문내역</a></td></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td><a href="<?php echo G5_SHOP_URL ?>/mypage_itemqalist.php" title="1:1문의">1:1문의</a></td></p><p><span class="Apple-tab-span" style="white-space:pre">			</span></tr></p><p><span class="Apple-tab-span" style="white-space:pre">			</span><tr></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td><a href="<?php echo G5_SHOP_URL ?>/today_view.php" title="오늘 본 상품">오늘 본 상품</a></td></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td><a href="<?php echo G5_SHOP_URL ?>/cart.php" title="장바구니">장바구니</a></td></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td><a href="<?php echo G5_SHOP_URL ?>/mypage_itemuselist.php" title="구매후기">구매후기</a></td></p><p><span class="Apple-tab-span" style="white-space:pre">			</span></tr></p><p><span class="Apple-tab-span" style="white-space:pre">			</span><tr></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td></td></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td></td></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td><a href="<?php echo G5_BBS_URL ?>/board.php?bo_table=ShopAlliance&sca=&sop=and&sfl=mb_id%2C1&stx=<?php echo $member['mb_id'] ?>" title="제휴제안">제휴제안</a></td></p><p><span class="Apple-tab-span" style="white-space:pre">			</span></tr></p><p><span class="Apple-tab-span" style="white-space:pre">		</span></tbody></p><p><span class="Apple-tab-span" style="white-space:pre">	</span></table></p><p></section></p><p><!-- } 회원정보 개요 끝 --></p><p> </p><p><!-- 주문 내역 목록 시작 { --></p><p><?php if (!$limit) { ?>총 <?php echo $cnt; ?> 건<?php } ?></p><p> </p><p><div class="tbl_head01 tbl_wrap"></p><p><span class="Apple-tab-span" style="white-space:pre">	</span><form name="frmoilist" id="orderinquiry_list" method="post" action="<?php echo $orderinquiry_del_url; ?>"></p><p><span class="Apple-tab-span" style="white-space:pre">		</span><table class="tbl_inquiry"></p><p><span class="Apple-tab-span" style="white-space:pre">			</span><colgroup></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><col width="30px"></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><col width="60px"></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><col width="100px"></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><col width="70px"></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><col width="425px"></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><col width="110px"></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><col width="120px"></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><col width="80px"></p><p><span class="Apple-tab-span" style="white-space:pre">			</span></colgroup></p><p><span class="Apple-tab-span" style="white-space:pre">			</span><thead></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><tr></p><p><span class="Apple-tab-span" style="white-space:pre">					</span><th scope="col"></p><p><span class="Apple-tab-span" style="white-space:pre">						</span><label for="ct_all" class="sound_only">상품 전체</label></p><p><span class="Apple-tab-span" style="white-space:pre">						</span><input type="checkbox" name="ct_all" value="1" id="ct_all"></p><p><span class="Apple-tab-span" style="white-space:pre">					</span></th></p><p><span class="Apple-tab-span" style="white-space:pre">					</span><th scope="col">번호</th></p><p><span class="Apple-tab-span" style="white-space:pre">					</span><th scope="col">주문번호</th></p><p><span class="Apple-tab-span" style="white-space:pre">					</span><th scope="col">이미지</th></p><p><span class="Apple-tab-span" style="white-space:pre">					</span><th scope="col">상품명</th></p><p><span class="Apple-tab-span" style="white-space:pre">					</span><th scope="col">상품구매금액</th></p><p><span class="Apple-tab-span" style="white-space:pre">					</span><th scope="col">주문일자</th></p><p><span class="Apple-tab-span" style="white-space:pre">					</span><th scope="col">상태</th></p><p><span class="Apple-tab-span" style="white-space:pre">				</span></tr></p><p><span class="Apple-tab-span" style="white-space:pre">			</span></thead></p><p><span class="Apple-tab-span" style="white-space:pre">			</span><tbody></p><p><span class="Apple-tab-span" style="white-space:pre">			</span><?php</p><p>/*</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>$sql = " SELECT *</p><p><span class="Apple-tab-span" style="white-space:pre">							</span>FROM {$g5['g5_shop_order_table']}</p><p><span class="Apple-tab-span" style="white-space:pre">							</span>WHERE mb_id = '{$member['mb_id']}'</p><p><span class="Apple-tab-span" style="white-space:pre">							</span>ORDER BY od_id desc</p><p><span class="Apple-tab-span" style="white-space:pre">							</span>$limit ";</p><p>*/</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>$sql = " SELECT </p><p><span class="Apple-tab-span" style="white-space:pre">							</span>*</p><p><span class="Apple-tab-span" style="white-space:pre">							</span>FROM {$g5['g5_shop_cart_table']} a</p><p><span class="Apple-tab-span" style="white-space:pre">							</span>LEFT JOIN {$g5['g5_shop_order_table']} b</p><p><span class="Apple-tab-span" style="white-space:pre">							</span>ON a.od_id = b.od_id</p><p><span class="Apple-tab-span" style="white-space:pre">							</span>WHERE b.mb_id = '{$member['mb_id']}' AND a.od_id = b.od_id</p><p><span class="Apple-tab-span" style="white-space:pre">							</span>GROUP BY a.it_name, a.od_id</p><p><span class="Apple-tab-span" style="white-space:pre">							</span>ORDER BY a.od_id DESC</p><p><span class="Apple-tab-span" style="white-space:pre">							</span>$limit</p><p><span class="Apple-tab-span" style="white-space:pre">							</span>";</p><p>print_r ($sql);</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre">				</span>$result = sql_query($sql);</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>$num = 0;</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>$num = $total_count - ($page - 1) * $rows + $i;</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>for ($i=0; $row=sql_fetch_array($result); $i++)</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>{</p><p>//<span class="Apple-tab-span" style="white-space:pre">					</span>$od_id = $row['od_id'];</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre">					</span>$sql2 = "SELECT </p><p><span class="Apple-tab-span" style="white-space:pre">								</span>a.od_id,</p><p><span class="Apple-tab-span" style="white-space:pre">								</span>a.it_id,</p><p><span class="Apple-tab-span" style="white-space:pre">								</span>a.mb_id,</p><p><span class="Apple-tab-span" style="white-space:pre">								</span>a.it_name,</p><p><span class="Apple-tab-span" style="white-space:pre">								</span>a.io_price,</p><p><span class="Apple-tab-span" style="white-space:pre">								</span>b.od_id,</p><p><span class="Apple-tab-span" style="white-space:pre">								</span>b.mb_id</p><p><span class="Apple-tab-span" style="white-space:pre">								</span>FROM {$g5['g5_shop_cart_table']} a</p><p><span class="Apple-tab-span" style="white-space:pre">								</span>LEFT JOIN {$g5['g5_shop_order_table']} b</p><p><span class="Apple-tab-span" style="white-space:pre">								</span>ON a.od_id = b.od_id</p><p><span class="Apple-tab-span" style="white-space:pre">								</span>WHERE it_id = {$row['it_id']}</p><p><span class="Apple-tab-span" style="white-space:pre">								</span>";</p><p>/*</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>$sql2 = "SELECT </p><p><span class="Apple-tab-span" style="white-space:pre">								</span>od_id,</p><p><span class="Apple-tab-span" style="white-space:pre">								</span>it_id,</p><p><span class="Apple-tab-span" style="white-space:pre">								</span>mb_id,</p><p><span class="Apple-tab-span" style="white-space:pre">								</span>it_name,</p><p><span class="Apple-tab-span" style="white-space:pre">								</span>io_price</p><p><span class="Apple-tab-span" style="white-space:pre">								</span>FROM {$g5['g5_shop_cart_table']}</p><p><span class="Apple-tab-span" style="white-space:pre">								</span>WHERE it_id = {$row['it_id']}</p><p><span class="Apple-tab-span" style="white-space:pre">								</span>";</p><p>*/</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>$result2 = sql_fetch($sql2);</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>$image = get_it_image($result2['it_id'], 70, 70);</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>$uid = md5($row['od_id'].$row['od_time'].$row['od_ip']);</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre">					</span>if ($it_options) {</p><p><span class="Apple-tab-span" style="white-space:pre">						</span>$it_options = print_item_options($row['it_id'], $s_cart_id);</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>} else {</p><p><span class="Apple-tab-span" style="white-space:pre">						</span>$it_options = "<p class=\"opt_list\">".$row['it_name']." ".$row['ct_qty']."개 (+".number_format($row['ct_price'])."원)</p>";</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>}</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre">					</span>switch($row['od_status']) {</p><p><span class="Apple-tab-span" style="white-space:pre">						</span>case '주문':</p><p><span class="Apple-tab-span" style="white-space:pre">							</span>$od_status = '입금확인중';</p><p><span class="Apple-tab-span" style="white-space:pre">							</span>break;</p><p><span class="Apple-tab-span" style="white-space:pre">						</span>case '입금':</p><p><span class="Apple-tab-span" style="white-space:pre">							</span>$od_status = '완료';</p><p><span class="Apple-tab-span" style="white-space:pre">							</span>break;</p><p><span class="Apple-tab-span" style="white-space:pre">						</span>case '준비':</p><p><span class="Apple-tab-span" style="white-space:pre">							</span>$od_status = '상품준비중';</p><p><span class="Apple-tab-span" style="white-space:pre">							</span>break;</p><p><span class="Apple-tab-span" style="white-space:pre">						</span>case '배송':</p><p><span class="Apple-tab-span" style="white-space:pre">							</span>$od_status = '상품배송';</p><p><span class="Apple-tab-span" style="white-space:pre">							</span>break;</p><p><span class="Apple-tab-span" style="white-space:pre">						</span>case '완료':</p><p><span class="Apple-tab-span" style="white-space:pre">							</span>$od_status = '완료';</p><p><span class="Apple-tab-span" style="white-space:pre">							</span>break;</p><p><span class="Apple-tab-span" style="white-space:pre">						</span>default:</p><p><span class="Apple-tab-span" style="white-space:pre">							</span>$od_status = '주문취소';</p><p><span class="Apple-tab-span" style="white-space:pre">							</span>break;</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>}</p><p><span class="Apple-tab-span" style="white-space:pre">					</span>$num--;</p><p><span class="Apple-tab-span" style="white-space:pre">					</span></p><p><span class="Apple-tab-span" style="white-space:pre">					</span>for($j=0; $j < count($result2['it_name']); $j++) {</p><p><span class="Apple-tab-span" style="white-space:pre">			</span>?></p><p><span class="Apple-tab-span" style="white-space:pre">			</span><tr></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td rowspan=""></p><p><span class="Apple-tab-span" style="white-space:pre">					</span><label for="ct_chk_<?php echo $i; ?>" class="sound_only">주문</label></p><p><span class="Apple-tab-span" style="white-space:pre">					</span><input type="checkbox" name="ct_chk[<?php echo $i; ?>]" value="1" id="ct_chk_<?php echo $i; ?>"></p><p><span class="Apple-tab-span" style="white-space:pre">				</span></td></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td rowspan=""></p><p><span class="Apple-tab-span" style="white-space:pre">					</span><?php echo $num; ?></p><p><span class="Apple-tab-span" style="white-space:pre">				</span></td></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td rowspan=""></p><p><span class="Apple-tab-span" style="white-space:pre">					</span><input type="hidden" name="it_id[<?php echo $i; ?>]" value="<?php echo $row['it_id']; ?>"></p><p><span class="Apple-tab-span" style="white-space:pre">					</span><input type="hidden" name="od_id[<?php echo $i; ?>]" value="<?php echo $row['od_id']; ?>"></p><p><span class="Apple-tab-span" style="white-space:pre">					</span><a href="<?php echo G5_SHOP_URL; ?>/orderinquiryview.php?od_id=<?php echo $row['od_id']; ?>&uid=<?php echo $uid; ?>"><?php echo $row['od_id']; ?></a></p><p><span class="Apple-tab-span" style="white-space:pre">				</span></td></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td class="td_image"></p><p><span class="Apple-tab-span" style="white-space:pre">					</span><a href="./item.php?it_id=<?php echo $row['it_id']; ?>"></p><p><span class="Apple-tab-span" style="white-space:pre">						</span><?php echo $image; ?></p><p><span class="Apple-tab-span" style="white-space:pre">					</span></a></p><p><span class="Apple-tab-span" style="white-space:pre">				</span></td></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td></p><p><span class="Apple-tab-span" style="white-space:pre">					</span><p></p><p><span class="Apple-tab-span" style="white-space:pre">						</span><a href="./item.php?it_id=<?php echo $row['it_id']; ?>"></p><p><span class="Apple-tab-span" style="white-space:pre">							</span><?php echo $row['it_name']; ?></p><p><span class="Apple-tab-span" style="white-space:pre">						</span></a></p><p><span class="Apple-tab-span" style="white-space:pre">						</span>
</p><p><span class="Apple-tab-span" style="white-space:pre">						</span><?php if($it_options) { ?></p><p><span class="Apple-tab-span" style="white-space:pre">							</span><?php echo $it_options; ?></p><p><span class="Apple-tab-span" style="white-space:pre">						</span><?php } ?></p><p><span class="Apple-tab-span" style="white-space:pre">					</span></p></p><p><span class="Apple-tab-span" style="white-space:pre">				</span></td></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td rowspan="" class="td_numbig"></p><p><span class="Apple-tab-span" style="white-space:pre">					</span><?php //echo display_price($row['od_cart_price'] + $row['od_send_cost'] + $row['od_send_cost2']); ?></p><p><span class="Apple-tab-span" style="white-space:pre">					</span><?php echo display_price(($row['ct_price'] * $row['ct_qty']) + $row['io_price']); ?></p><p><span class="Apple-tab-span" style="white-space:pre">				</span></td></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td rowspan=""><?php echo substr($row['od_time'],2,14); ?> (<?php echo get_yoil($row['od_time']); ?>)</td></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td rowspan=""><?php echo $od_status; ?></td></p><p><span class="Apple-tab-span" style="white-space:pre">			</span></tr></p><p><span class="Apple-tab-span" style="white-space:pre">			</span><?php</p><p><span class="Apple-tab-span" style="white-space:pre">			</span>}</p><p><span class="Apple-tab-span" style="white-space:pre">			</span>} // 첫번째 for</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre">			</span>if ($i == 0)</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>echo '<tr><td colspan="8" class="empty_table">주문 내역이 없습니다.</td></tr>';</p><p><span class="Apple-tab-span" style="white-space:pre">			</span>?></p><p> </p><p><span class="Apple-tab-span" style="white-space:pre">			</span><tr></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td rowspan="3">1</td></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td rowspan="3">2</td></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td rowspan="3">3</td></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td>4</td></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td>5</td></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td rowspan="3">6</td></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td rowspan="3">7</td></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td rowspan="3">8</td></p><p><span class="Apple-tab-span" style="white-space:pre">			</span></tr></p><p><span class="Apple-tab-span" style="white-space:pre">			</span><tr></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td>4</td></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td>5</td></p><p><span class="Apple-tab-span" style="white-space:pre">			</span></tr></p><p><span class="Apple-tab-span" style="white-space:pre">			</span><tr></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td>4</td></p><p><span class="Apple-tab-span" style="white-space:pre">				</span><td>5</td></p><p><span class="Apple-tab-span" style="white-space:pre">			</span></tr></p><p><span class="Apple-tab-span" style="white-space:pre">			</span></tbody></p><p><span class="Apple-tab-span" style="white-space:pre">		</span></table></p><p><span class="Apple-tab-span" style="white-space:pre">		</span><?php  if ($total_count != 0)  { ?></p><p><span class="Apple-tab-span" style="white-space:pre">		</span><div class="inquiry_btn"></p><p><span class="Apple-tab-span" style="white-space:pre">			</span><input type="hidden" name="url" value="./orderinquiry.php"></p><p><span class="Apple-tab-span" style="white-space:pre">			</span><input type="hidden" name="records" value="<?php echo $i; ?>"></p><p><span class="Apple-tab-span" style="white-space:pre">			</span><input type="hidden" name="act" value=""></p><p><span class="Apple-tab-span" style="white-space:pre">			</span><button type="button" onclick="return form_check('alldelete');" class="btn01">전체삭제</button></p><p><span class="Apple-tab-span" style="white-space:pre">			</span><button type="button" onclick="return form_check('seldelete');" class="btn01">선택삭제</button></p><p><span class="Apple-tab-span" style="white-space:pre">		</span></div></p><p><span class="Apple-tab-span" style="white-space:pre">		</span><?php } ?></p><p><span class="Apple-tab-span" style="white-space:pre">	</span></form></p><p><span class="Apple-tab-span" style="white-space:pre">	</span><?php echo $row['od_id'];?></p><p></div></p><p> </p><p><script type="text/javascript"></p><p><span class="Apple-tab-span" style="white-space:pre">	</span>$(function() {</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>// 모두선택</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>$("input[name=ct_all]").click(function() {</p><p><span class="Apple-tab-span" style="white-space:pre">			</span>if($(this).is(":checked"))</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>$("input[name^=ct_chk]").attr("checked", true);</p><p><span class="Apple-tab-span" style="white-space:pre">			</span>else</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>$("input[name^=ct_chk]").attr("checked", false);</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>});</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>});</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre">	</span>function form_check(act) {</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>var f = document.frmoilist;</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>var cnt = f.records.value;</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre">		</span>if (act == "alldelete")</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>{</p><p><span class="Apple-tab-span" style="white-space:pre">			</span>if(confirm("정말 삭제하시겠습니까?")) {</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>f.act.value = act;</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>f.submit();</p><p><span class="Apple-tab-span" style="white-space:pre">			</span>} else {</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>return;</p><p><span class="Apple-tab-span" style="white-space:pre">			</span>}</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>}</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>else if (act == "seldelete")</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>{</p><p><span class="Apple-tab-span" style="white-space:pre">			</span>if($("input[name^=ct_chk]:checked").size() < 1) {</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>alert("삭제하실 주문내역을 하나 이상 선택해 주십시오.");</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>return false;</p><p><span class="Apple-tab-span" style="white-space:pre">			</span>}</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre">			</span>if(confirm("정말 삭제하시겠습니까?")) {</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>f.act.value = act;</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>f.submit();</p><p><span class="Apple-tab-span" style="white-space:pre">			</span>} else {</p><p><span class="Apple-tab-span" style="white-space:pre">				</span>return;</p><p><span class="Apple-tab-span" style="white-space:pre">			</span>}</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>}</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>return true;</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>}</p><p></script></p><p><!-- } 주문 내역 목록 끝 --></p><p>

 

댓글을 작성하려면 로그인이 필요합니다.

답변 1개

</p><p>while(<span style="font-size: 14.6667px;">$row = </span><span style="font-size: 11pt;">sql_fetch_array($result)) {</span></p><p><span style="font-size: 11pt;">    echo $row['od_id'];</span></p><p>}

로그인 후 평가할 수 있습니다

답변에 대한 댓글 1개

l
lacomparte
8년 전
위의 소스는
row 한줄씩 질의할때 마다
주문번호를 찍으라는 건가요?

한가지 더 궁금한건, (주문1건에 대해 2가지 이상 상품이 존재할경우)
상품명과 이미지는 가져오는데..
옵션명을
두번째 상품부터 못가져 옵니다 ㅠ

댓글을 작성하려면 로그인이 필요합니다.

답변을 작성하려면 로그인이 필요합니다.

로그인