='2' order by B.payment_day desc,B.payment_time desc "; /* `uid` int(11) NOT NULL auto_increment, `id` varchar(20) default NULL, `goods_id` varchar(20) default NULL, `buy_day` varchar(16) default NULL, `goods_num` varchar(10) default NULL, `goods_color` varchar(255) default NULL, `goods_size` varchar(255) default NULL, `goods_price` varchar(100) default NULL, `pay_modus` varchar(10) default NULL, `goods_memo` text, `gubun` varchar(5) default NULL, `payment_day` varchar(8) default NULL, `payment_time` varchar(6) default NULL, `id_phone` varchar(20) default NULL, `id_add` varchar(255) default NULL, `buy_key` varchar(3) default NULL, `enrollment_day` varchar(20) default NULL, L.id, --등록자 L.price, --가격 L.date, --등록날짜 L.start_day, --판매날짜 L.end_day, --종료날짜 L.max_num, --최대신청인원 L.img_name1, --상품이미지 L.img_name2, --상품이미지 L.img_name3, --상품이미지 L.img_name4, --상품이미지 L.img_name5, --상품이미지 L.img_name6, --상품이미지 L.img_name7, --상품이미지 L.goods_name, --상품명 L.explication, --설명 L.service, --서비스 유무 L.division, --구분 L.buy_system, --신청 형태 L.company, --제조회사 L.item_color, -- L.item_size, -- L.view_gubun, -- L.item_num, -- L.delivery_money --배송료 */ $query = mysql_query($selectA); if(!$query) { $msg = mysql_error($dbconn); mysql_close($dbconn); echo $msg; exit; } $a = 0; $num =0; while($row = mysql_fetch_row($query)) { $M_id[$a] = $row[0]; $M_goods_id[$a] = $row[1]; $M_goods_num[$a] = $row[2]; $M_goods_color[$a] = iconv("euckr","utf-8",$row[3]); $M_goods_size[$a] = iconv("euckr","utf-8",$row[4]); $M_goods_price[$a] = $row[5]; $M_price[$a] = $row[6]; $M_uid[$a] = $row[7]; $M_id[$a] = $row[8]; $M_price[$a] = $row[9]; $M_date[$a] = $row[10]; $M_start_day[$a] = $row[11]; $M_end_day[$a] = $row[12]; $M_max_num[$a] = $row[13]; $M_img_name1[$a] = $row[14]; $M_img_name2[$a] = $row[15]; $M_img_name3[$a] = $row[16]; $M_img_name4[$a] = $row[17]; $M_img_name5[$a] = $row[18]; $M_img_name6[$a] = $row[19]; $M_img_name7[$a] = $row[20]; $M_goods_name[$a] = iconv("euckr","utf-8",$row[21]); $M_explication[$a] = $row[22]; $M_service[$a] = $row[23]; $M_division[$a] = $row[24]; $M_buy_system[$a] = $row[25]; $M_company[$a] = $row[26]; $M_item_color[$a] = $row[27]; $M_item_size[$a] = $row[28]; $M_view_gubun[$a] = $row[29]; $M_item_num[$a] = $row[30]; $M_delivery_money[$a] = $row[31]; $M_uid[$a] = $row[32]; $M_payment_day[$a] = $row[33]; $M_payment_time[$a] = $row[34]; $M_buy_progress[$a] = $row[35]; $M_return_progress[$a] = $row[36]; $M_return_day[$a] = $row[37]; $a++; $num++; } $M_goods_price_total =0; $M_delivery_money_total =0; if($num>0) { for($b=0;$b<$num;$b++) { $M_goods_price_total = $M_goods_price_total+$M_goods_price[$b]; $M_delivery_money_total = $M_delivery_money_total+$M_delivery_money[$b]; switch($M_buy_progress[$b]) { default: case "0" : $M_buy_progress_name[$b] = "결제 대기"; break; case "1" : $M_buy_progress_name[$b] = "결제 완료"; break; case "2" : $M_buy_progress_name[$b] = "상품준비중"; break; case "3" : $M_buy_progress_name[$b] = "배송준비중"; break; case "4" : $M_buy_progress_name[$b] = "배송중"; break; case "5" : $M_buy_progress_name[$b] = "배송완료"; break; } ?>

구매내역	상품명 / 옵션정보	주문금액	진행상태
..	| / 개	원		상품이 이미 발송되어 환불을 원하시면 반품신청을 하셔야 합니다. 반품신청 배송조회