ab1628的部落格

20141021 orders_detail_del.php

<?php require_once('../../../Connections/allianz.php'); ?>
<?php
$varp_id = ""; if (isset($_REQUEST["p_id"]) ){ $varp_id =$_REQUEST["p_id"];}

mysql_select_db($database_allianz, $allianz); // 連線資料庫
$del = " delete ";
$del .= " from orders_detail01 ";
$del .= " where 1=1 ";
$del .= " and p_id = ".$varp_id." ";
echo " del = ".$del."<br>";

$Recordset1 = mysql_query($del, $allianz) or die(mysql_error()); // 執行查詢語法
$row_Recordset1 = mysql_fetch_assoc($Recordset1); // 把查詢的結果帶到$row_Recordset1[]陣列中

mysql_select_db($database_allianz, $allianz); // 連線資料庫
$del2 = " delete ";
$del2 .= " from products01 ";
$del2 .= " where 1=1 ";
$del2 .= " and p_id = ".$varp_id." ";
echo " del2 = ".$del2."<br>";

$Recordset2 = mysql_query($del2, $allianz) or die(mysql_error()); // 執行查詢語法
$row_Recordset2 = mysql_fetch_assoc($Recordset2); // 把查詢的結果帶到$row_Recordset1[]陣列中

?>