Changeset 2598

Timestamp:

2006/08/29 12:44:49 (18 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/order/edit.php (modified) (1 diff)

temp/trunk/html/admin/order/edit.php

@@ -283 +283 @@
     $sql .= " SET";
     $sql .= "     payment_method = (SELECT payment_method FROM dtb_payment WHERE payment_id = ?)";
-    $sql .= "     ,deliv_data = (SELECT time FROM dtb_deliv_time WHERE time_id = ? deliv_id = (SELECT deliv_id FROM dtb_order WHERE order_id = ?))";
+    $sql .= "     ,deliv_data = (SELECT time FROM dtb_delivtime WHERE time_id = ? AND deliv_id = (SELECT deliv_id FROM dtb_order WHERE order_id = ?))";
     $sql .= " WHERE order_id = ?";
     $arrUpdData = array($sqlval['payment_id'], $sqlval['deliv_time_id'], $sqlval['order_id'], $sqlval['order_id']);