= '".date("YmdHi")."' ORDER BY ymd DESC,ut DESC LIMIT 0,3"; $nresult = $mysqli->query($sql); while($ncustomer = $nresult->fetch()){ $n_no = $ncustomer['no']; $n_ymd = $ncustomer['ymd']; $n_name = $ncustomer['name']; $n_link = $ncustomer['link']; $n_det = $ncustomer['det']; $n_cate = $ncustomer['cate']; $n_det = $ncustomer['det']; switch($n_link){ case 'det': $n_link = 'topics_detail.php?no='.$n_no; break; case 'link': $n_link = $n_det.'" target="_blank'; break; case 'file': $n_link = _HREF_MAS.$n_det.'" target="_blank'; break; default: } $youbi = date("w",strtotime($n_ymd)); $n_ymd = date("Y.m.d",strtotime($n_ymd)).'('.$youbi_array[$youbi].')'; $n_list .= ' TOPICS '.$n_ymd.' '.$n_name.' '; } if(!$n_list) $n_list = '※現在掲載中のお知らせはありません。'; $a_list = ''; $sql = "SELECT no, ymd, name, link, det, cate, det, ut FROM jirei WHERE sflg = '1' AND s_ymd <= '".date("YmdHi")."' AND e_ymd >= '".date("YmdHi")."' UNION ALL SELECT no, ymd, name, link, det, cate, det, ut FROM nendo WHERE sflg = '1' AND s_ymd <= '".date("YmdHi")."' AND e_ymd >= '".date("YmdHi")."' ORDER BY ymd DESC, ut DESC LIMIT 0,3 "; $aresult = $mysqli->query($sql); while($acustomer = $aresult->fetch()){ $a_no = $acustomer['no']; $a_ymd = $acustomer['ymd']; $a_name = $acustomer['name']; $a_link = $acustomer['link']; $a_det = $acustomer['det']; $a_cate = $acustomer['cate']; $a_det = $acustomer['det']; switch($a_link){ case 'det': $a_link = 'archive_detail.php?no='.$a_no; break; case 'link': $a_link = $a_det.'" target="_blank'; break; case 'file': $a_link = _HREF_MAS.$a_det.'" target="_blank'; break; default: } $youbi = date("w",strtotime($a_ymd)); $a_ymd = date("Y.m.d",strtotime($a_ymd)).'('.$youbi_array[$youbi].')'; $a_list .= ' 活動報告 '.$a_ymd.' '.$a_name.' '; } if(!$a_list) $a_list = '※現在掲載中の活動報告はありません。'; $html_str = HTML_IMPUT('index_tmp.html'); $html_str = str_replace('_TIME_STUMP', time(), $html_str); $html_str = str_replace('', $n_list, $html_str); $html_str = str_replace('', $a_list, $html_str); print($html_str); ?>