Changeset 4751 for temp/trunk
- Timestamp:
- 2006/09/14 20:08:53 (20 years ago)
- File:
-
- 1 edited
-
temp/trunk/html/admin/contents/index.php (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
temp/trunk/html/admin/contents/index.php
r4750 r4751 95 95 $arrData = split("-",$result[0]["cast_news_date"]); 96 96 97 sfprintr($arrData);98 99 97 $objPage->selected_year = $arrData[0]; 100 98 $objPage->selected_month =$arrData[1]; … … 143 141 144 142 //---- Á´¥Ç¡¼¥¿¼èÆÀ 145 //$sql = "SELECT *, EXTRACT(EPOCH FROM news_date) as news_date_unix FROM dtb_news WHERE del_flg = '0' ORDER BY rank DESC";146 143 $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"; 147 144 $objPage->list_data = $conn->getAll($sql);
Note: See TracChangeset
for help on using the changeset viewer.
