Changeset 17204 for branches/version-2/data/class/pages/admin/contents/LC_Page_Admin_Contents.php

Timestamp:

2008/04/04 14:49:30 (16 years ago)

Author:

satou

Message:

fixed by shutta (merge r17144)

File:

• branches/version-2/data/class/pages/admin/contents/LC_Page_Admin_Contents.php (modified) (2 diffs)

branches/version-2/data/class/pages/admin/contents/LC_Page_Admin_Contents.php

@@ -112 +112 @@
         //----　編集データ取得
         if ($_POST["mode"] == "search" && is_numeric($_POST["news_id"])) {
-            $sql = "SELECT *, cast(substring(news_date,1, 10) as date) as cast_news_date FROM dtb_news WHERE news_id = ? ";
+            $sql = "SELECT *, cast(news_date as date) as cast_news_date FROM dtb_news WHERE news_id = ? ";
             $result = $conn->getAll($sql, array($_POST["news_id"]));
             foreach($result[0] as $key => $val ){
@@ -168 +168 @@
 
         //---- 全データ取得
-        $sql = "SELECT *, cast(substring(news_date,1, 10) as date) as cast_news_date FROM dtb_news WHERE del_flg = '0' ORDER BY rank DESC";
+        $sql = "SELECT *, cast(news_date as date) as cast_news_date FROM dtb_news WHERE del_flg = '0' ORDER BY rank DESC";
         $this->list_data = $conn->getAll($sql);
         $this->line_max = count($this->list_data);