require_once('inc/com.php'); $get_new = ''; $get_y = ''; $SQL = ''; $SQL .= ' SELECT left(n_date,4) as date_y '; $SQL .= ' FROM i_news '; $SQL .= ' WHERE active = 1 '; $SQL .= ' GROUP BY date_y '; $SQL .= ' ORDER BY date_y desc '; $objRecord5 = mysql_query($SQL); while ($item5 = mysql_fetch_array($objRecord5)) { if($get_new=='') { $get_new = "${item5['date_y']}"; } if($_GET['y']=="${item5['date_y']}") { $get_y = "${item5['date_y']}"; } } if($get_y=='') header('Location: news.php?y='.$get_new); ?>
公開年 | $SQL = ''; $SQL .= ' SELECT left(n_date,4) as date_y '; $SQL .= ' FROM i_news '; $SQL .= ' WHERE active = 1 '; $SQL .= ' GROUP BY date_y '; $SQL .= ' ORDER BY date_y desc '; $objRecord5 = mysql_query($SQL); while ($item5 = mysql_fetch_array($objRecord5)) { ?>年 } ?> |
---|