Changeset 5142 for temp/trunk

Timestamp:

2006/09/19 13:55:41 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/design/main_edit.php (modified) (1 diff)

temp/trunk/html/admin/design/main_edit.php

@@ -103 +103 @@
     
     if ($page_id_old != "") {
+        // ÅÐÏ¿¥Ç¡¼¥¿¤ò¼èÆÀ
+        $sql = "SELECT 0, target_id, bloc_id, bloc_row FROM dtb_blocposition WHERE page_id = ?";
+        $ret = $objDBConn->query($sql,array($page_id_old));
+        
         // blocposition ¤òÊ£À½
-        $sql = " insert into dtb_blocposition ";
-        $sql .= " select ";
-        $sql .= "     0,";
+        $sql = " insert into dtb_blocposition (";
+        $sql .= "     page_id,";
         $sql .= "     target_id,";
         $sql .= "     bloc_id,";
         $sql .= "     bloc_row";
-        $sql .= " from dtb_blocposition";
-        $sql .= " where page_id = ?";
-        $ret = $objDBConn->query($sql,array($page_id_old));
+        $sql .= "     )values(?, ?, ?, ?)";
+        $ret = $objDBConn->query($sql,$ret[0]);
     }