 |
|
จากโคตนี้อะครับ
if($do2='doadd'){
$date_order = date("Y/m/d H:i:s");
$sql2="INSERT INTO mos_order (order_by,order_date,order_no,order_status) values ('$member_code','$date_order','$order_no','1')";
$result1=mysql_db_query($dbname,$sql2);
echo mysql_error();
$result1=true ;}
if($result1){
$sql1="select * from mos_order where order_by='$member_code' and order_date='$date_order' ";
$rs=mysql_db_query($dbname,$sql1);
$row1=mysql_fetch_array($rs);
$order_id=$row1['order_id'];
while(list($pd_id,$quentity) = each($product)) {
$sql_p="select * from mos_prd where pd_id='$pd_id'";
$rs_p=mysql_db_query($dbname,$sql_p);
$row_p=mysql_fetch_array($rs_p);
$pd_price=$row_p['pd_price'];
$pd_name=$row_p['pd_name'];
$sql_item = "insert into mos_orderdetail (member_code,order_date,pd_name,pd_id,pd_price,order_qty,order_no) values ('$member_code','$date_order','$pd_name','$pd_id','$pd_price','$quentity','$order_no') ";
$rs_item = mysql_db_query($dbname,$sql_item) ;
echo mysql_error();
//echo "<META HTTP-EQUIV=\"Refresh\" CONTENT=\"5;URL=index.php \">";
}
}
session_destroy("product");
ทำไมมันเป็นแบบนี้ครับ
Tag : - - - -
|
|
|
 |
 |
 |
 |
| Date :
2010-03-30 23:16:13 |
By :
ddsiam |
View :
898 |
Reply :
6 |
|
 |
 |
 |
 |
|
|
|
|
 |
