2100 ){ $year = date("Y"); } $db = new Class_DB; $sql = sprintf( "SELECT * FROM D_NEWS WHERE status = '1' AND category = 2 AND year = %u AND (st_time IS NULL OR st_time < CURRENT_TIMESTAMP ) AND (ed_time IS NULL OR ed_time > CURRENT_TIMESTAMP) ORDER BY date DESC", $year ); $db->query( $sql ); $data = array(); while( $row = $db->fetch() ){ $data[] = $row; } // 年リスト $db->query( "SELECT DISTINCT year FROM D_NEWS WHERE status = '1' AND category = 2 AND (st_time IS NULL OR st_time < CURRENT_TIMESTAMP ) AND (ed_time IS NULL OR ed_time > CURRENT_TIMESTAMP) "); $yearlist = array(); while( $row = $db->fetch() ){ $yearlist[] = $row['year']; } $smarty->assign('title_img', 'news_head_floor.gif'); $smarty->assign('icon_img', array( 1 => 'icon_federation.gif', 2 => 'icon_floor.gif', 3 => 'icon_neo.gif') ); $smarty->assign('icon_alt', array( 1 => '連盟からのお知らせ', 2 => 'フロアボール', 3 => 'ネオホッケー') ); $smarty->assign('index', 'floor_index.html' ); $smarty->assign('year', $year ); $smarty->assign('yearlist', $yearlist ); $smarty->assign('data', $data ); $smarty->display('topics/index.html'); ?>