01.
02.
03.$SID = session_id();
04.$region = $_POST['inRegion'];
05.include("../connect_database/connect.php");
06.
07.
08.
09.$sql = "SELECT * FROM tb_basket AS b, tb_delivery AS d WHERE b.basket_s_id=d.s_id and b.basket_session='$SID' ";
10.$result = mysql_query($sql);
11.while($data = mysql_fetch_array($result)){
12.$ShopName = $data['basket_s_name'];
13.$ProductName = $data["basket_p_name"];
14.$ProductPrice = $data['basket_p_price'];
15.$ProductItem = $data['basket_p_item'];
16.
17.
18.
19.if($region=="North"){ $delivery = $data['north']; }
20.if($region=="West"){ $delivery = $data['west']; }
21.if($region=="East"){ $delivery = $data['east']; }
22.if($region=="Center"){ $delivery = $data['center']; }
23.if($region=="South"){ $delivery = $data['south']; }
24.
25.
26.
27.$sql2 = "INSERT INTO tb_order_detail";
28.$sql2 .= "( order_id, order_shop_name, order_product_name, order_product_price, order_product_item, order_delivery )";
29.$sql2 .= "VALUES";
30.$sql2 .= "( '".$_POST['inOrderID']."' , '".$ShopName."' , '".$ProductName."' , '".$ProductPrice."' , '".$ProductItem."', '".$delivery."' )";
31.$result2 = mysql_query($sql2);
32.}
Quote:
