Changeset 8974 for temp

Timestamp:

2006/11/26 18:48:38 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk/html

Files:

• install/user_data/templates/detail.tpl (modified) (previous)
• products/detail.php (modified) (1 diff)

temp/trunk/html/products/detail.php

@@ -86 +86 @@
     } else {
         //±ÜÍ÷ÍúÎò¤ÎÃæ¤Ç°ìÈָŤ¤¤â¤Î¤òºï½ü¤·¤Æ¿·µ¬ÄɲÃ
-        $where = "customer_id = ? AND update_date = (SELECT MIN(update_date) FROM ".$table." WHERE customer_id = ? ) ";
-        $arrval = array($objCustomer->getValue("customer_id"), $objCustomer->getValue("customer_id"));
+        $oldsql = "SELECT MIN(update_date) FROM ".$table." WHERE customer_id = ?";
+        $old = $objQuery->getone($oldsql, array($objCustomer->getValue("customer_id")));
+        $where = "customer_id = ? AND update_date = ? ";
+        $arrval = array($objCustomer->getValue("customer_id"), $old);
         //ºï½ü
         $objQuery->delete($table, $where, $arrval);