Changeset 4752 for temp/trunk/html

Timestamp:

2006/09/14 20:27:41 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/contents/index.php (modified) (1 diff)

temp/trunk/html/admin/contents/index.php

@@ -244 +244 @@
         $_POST["link_method"] = 1;
     }
+    
+    //rank¤ÎºÇÂç+1¤ò¼èÆÀ¤¹¤ë
+    $rank_max = $conn->getone("SELECT MAX(rank) + 1 FROM dtb_news WHERE del_flg = '0'");
 
     $sql = "INSERT INTO dtb_news (news_date, news_title, creator_id, news_url, link_method, news_comment, rank)
-            VALUES ( ?,?,?,?,?,? , (SELECT MAX(rank) + 1 FROM dtb_news WHERE del_flg = '0'))";
-    $arrRegist = array($registDate, $_POST["news_title"], $_SESSION['member_id'],  $_POST["news_url"], $_POST["link_method"], $_POST["news_comment"]);
+            VALUES ( ?,?,?,?,?,?,?)";
+    $arrRegist = array($registDate, $_POST["news_title"], $_SESSION['member_id'],  $_POST["news_url"], $_POST["link_method"], $_POST["news_comment"], $rank_max);
 
     $conn->query($sql, $arrRegist);