ab1628的部落格

訂單+訂單明細 (刪除)

orders_detail_del.php
<?php require_once('../../../Connections/allianz.php'); ?>
<?php
$varo_id = ""; if (isset($_REQUEST["o_id"]) ){ $varo_id =$_REQUEST["o_id"];}
$varod_id = ""; if (isset($_REQUEST["od_id"]) ){ $varod_id =$_REQUEST["od_id"];}
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$del  = " delete  ";
$del .= " from orders_detail01 ";
$del .= " where 1=1";
$del .= " and od_id = ".$varod_id." ";
//echo " del = ".$del."<br>";

$Recordset1 = mysql_query($del, $allianz) or die(mysql_error()); // 執行查詢語法
$row_Recordset1 = mysql_fetch_assoc($Recordset1); // 把查詢的結果帶到$row_Recordset1[]陣列中
header(sprintf("Location: %s", "orders_detail_qry.php?o_id=" .$varo_id. "" ));

?>