'" .date("Y"). "-04-01';";
$result = mysql_query($sql, $Connect_ID);
$num_rows = mysql_num_rows($result);
// 登録あり
if ($num_rows > 0) {
echo "
\n";
}
//メモリ開放
mysql_free_result($result);
}
$sql = "select seminor_id,seminor_title,bosyuu_flg,to_bosyuu_date,jissibi from seminor_syousai where bunrui=0 and jissibi between '" .substr($nengetu1,0,4). "-" .substr($nengetu1,7,2). "-01' and last_day('" .substr($nengetu8,0,4). "-" .substr($nengetu8,7,2). "-01') order by jissibi";
$result = mysql_query($sql, $Connect_ID);
$num_rows = mysql_num_rows($result);
//スポットセミナー登録件数照会
if ($nengetu[11] == "") {
$sql = "select seminor_id,seminor_title,bosyuu_flg,to_bosyuu_date,jissibi from seminor_syousai where bunrui=1 and jissibi between '" .substr($nengetu[0],0,4). "-" .substr($nengetu[0],7,2). "-01' and last_day('" .substr($nengetu[9],0,4). "-" .substr($nengetu[9],7,2). "-01') order by jissibi";
} else {
$sql = "select seminor_id,seminor_title,bosyuu_flg,to_bosyuu_date,jissibi from seminor_syousai where bunrui=1 and jissibi between '" .substr($nengetu[0],0,4). "-" .substr($nengetu[0],7,2). "-01' and last_day('" .substr($nengetu[11],0,4). "-" .substr($nengetu[11],7,2). "-01') order by jissibi";
}
//$sql = "select seminor_id,seminor_title,bosyuu_flg,to_bosyuu_date,jissibi from seminor_syousai where bunrui=1 and jissibi < '" .date("Y-m-d",strtotime("+0 month",$base_timestamp))."'";
$result = mysql_query($sql, $Connect_ID);
$num_rows = mysql_num_rows($result);
//メモリ開放
mysql_free_result($result);
if ($num_rows <> 0) {
echo"
セミナーカレンダーリンクがないところは詳細が決まり次第、順次追加していきます
";
}
echo"
";
echo"
";
//スポットセミナー登録件数によってタブの出力を変える
//if ($num_rows <> 0) {
// echo"";
// echo"- スポットセミナー
";
//} else {
echo"";
//}
echo"
";
echo"
";
echo"
\n";
echo "
\n";
//セミナー内容出力（関数呼び出し）
for ($cnt=0; $cnt<$roop;$cnt++) {
print_seminor($nengetu[$cnt],"left",$cnt);
print_seminor($nengetu[$cnt+$roop],"right",$cnt+$roop);
}
echo"
\n";
echo "
\n";
//現在日時より古い日付でセミナー実施日が登録されていれば、リンク出力
$sql = "select seminor_id,seminor_title,bosyuu_flg,to_bosyuu_date,jissibi from seminor_syousai where bunrui=0 and jissibi < '" .date("Y-m-d",strtotime("+0 month",$base_timestamp))."'";
$result = mysql_query($sql, $Connect_ID);
$num_rows = mysql_num_rows($result);
echo "
※同業他社様並びに個人等からのお申し込みはお断りさせて頂く場合が御座います。予めご了承下さい。
";
echo "
";
if ($num_rows > 0) {
echo "
";
}
echo "
\n";
//メモリ開放
mysql_free_result($result);
//スポットセミナー登録件数照会
if ($nengetu[11] == "") {
$sql = "select seminor_id,seminor_title,bosyuu_flg,to_bosyuu_date,jissibi from seminor_syousai where bunrui=1 and jissibi between '" .substr($nengetu[0],0,4). "-" .substr($nengetu[0],7,2). "-01' and last_day('" .substr($nengetu[9],0,4). "-" .substr($nengetu[9],7,2). "-01') order by jissibi";
} else {
$sql = "select seminor_id,seminor_title,bosyuu_flg,to_bosyuu_date,jissibi from seminor_syousai where bunrui=1 and jissibi between '" .substr($nengetu[0],0,4). "-" .substr($nengetu[0],7,2). "-01' and last_day('" .substr($nengetu[11],0,4). "-" .substr($nengetu[11],7,2). "-01') order by jissibi";
}
$result = mysql_query($sql, $Connect_ID);
$num_rows = mysql_num_rows($result);
if ($num_rows == 0) {
echo"