Changeset 17204 for branches/version-2/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_News.php
- Timestamp:
- 2008/04/04 14:49:30 (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_News.php
r16741 r17204 98 98 function lfGetNews(){ 99 99 $conn = new SC_DBConn(); 100 $sql = "SELECT *, cast( substring(news_date,1,10)as date) as news_date_disp FROM dtb_news WHERE del_flg = '0' ORDER BY rank DESC";100 $sql = "SELECT *, cast(news_date as date) as news_date_disp FROM dtb_news WHERE del_flg = '0' ORDER BY rank DESC"; 101 101 $list_data = $conn->getAll($sql); 102 102 return $list_data;
Note: See TracChangeset
for help on using the changeset viewer.