source: temp/trunk/html/frontparts/bloc/news.php @ 5934

<?php
/*
 * Copyright(c) 2000-2006 LOCKON CO.,LTD. All Rights Reserved.
 *
 * http://www.lockon.co.jp/
 */
class LC_NewsPage {
    function LC_NewsPage() {
        /** ɬ¤ºÊѹ¹¤¹¤ë **/
        $this->tpl_mainpage = ROOT_DIR . BLOC_DIR.'news.tpl';   // ¥á¥¤¥ó
    }
}

$objSubPage = new LC_NewsPage();
$objSubView = new SC_SiteView();

//¿·Ãå¾ðÊó¼èÆÀ
$objSubPage->arrNews = lfGetNews();

$objSubView->assignobj($objSubPage);
$objSubView->display($objSubPage->tpl_mainpage);
//-----------------------------------------------------------------------------------------------------------------------------------
function lfGetNews(){
    $conn = new SC_DBConn();
    $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";
    $list_data = $conn->getAll($sql);
    return $list_data;  
}
?>