Changeset 4742 for temp

Timestamp:

2006/09/14 19:58:07 (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

@@ -88 +88 @@
 //----¡¡ÊÔ½¸¥Ç¡¼¥¿¼èÆÀ
 if ($_POST["mode"] == "search" && is_numeric($_POST["news_id"])) {
-    //$sql = "SELECT *, EXTRACT(EPOCH FROM news_date) AS news_date_unix FROM dtb_news WHERE news_id = ? ";
-    $sql = "SELECT * FROM dtb_news WHERE news_id = ? ";
+    $sql = "SELECT *, cast(substring(news_date,1, 10) 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 ){
         $objPage->$key = $val;
     }
-    sfprintr(split("-",$result[0]["news_date"]));
-/*  
-    $objPage->selected_year = date("Y", $result[0]["news_date_unix"]);      
-    $objPage->selected_month = date("m", $result[0]["news_date_unix"]);
-    $objPage->selected_day = date("d", $result[0]["news_date_unix"]);
-*/
+    $arrData = split("-",$result[0]["cast_news_date"]);
+
+    $objPage->selected_year = date("Y", $arrData[0]);       
+    $objPage->selected_month = date("m", $arrData[1]);
+    $objPage->selected_day = date("d", $arrData[2]);
+
     $objPage->edit_mode = "on";
 }