행사일정
$y = date('Y');
$y = $y - 1;
$m = date('m');
if($m < 4){
?>
년
for($i=11;$i<13;$i++){
$str = "";
$month_this = $y.str_pad($i, 2, "0", STR_PAD_LEFT)."00";
$month_next = $y.str_pad($i, 2, "0", STR_PAD_LEFT)."32";
$sql = "select count(*) as cnt from g5_write_schedule_event where wr_1 > '{$month_this}' AND wr_1 < '{$month_next}'";
$row = sql_fetch($sql);
$total_count = $row['cnt'];
if( $total_count > 0 ){
$str .= "
";
$str .= "
";
}
echo $str;
}
?>
";
$str .= "
";
$str .= " {$i}월
"; $str .= "";
$sql = "select * from g5_write_schedule_event where wr_1 > '{$month_this}' AND wr_1 < '{$month_next}' order by wr_1 asc";
$result = sql_query($sql);
for ($j=0; $row=sql_fetch_array($result); $j++) {
$sday = intval(substr($row['wr_1'],-2));
if( !trim($row['wr_2']) || $row['wr_1'] == $row['wr_2']){
$eday = "";
}else{
if( substr($row['wr_1'],-4,2) == substr($row['wr_2'],-4,2) )
$eday = "~". intval(substr($row['wr_2'],-2));
else
$eday = "~".intval(substr($row['wr_2'],-4,2))."/".intval(substr($row['wr_2'],-2));
}
$str .= "";
}
$str .= "
";
$str .= "년
for($i=1;$i<13;$i++){
$str = "";
$month_this = $y.str_pad($i, 2, "0", STR_PAD_LEFT)."00";
$month_next = $y.str_pad($i, 2, "0", STR_PAD_LEFT)."32";
$sql = "select count(*) as cnt from g5_write_schedule_event where wr_1 > '{$month_this}' AND wr_1 < '{$month_next}'";
$row = sql_fetch($sql);
$total_count = $row['cnt'];
if( $total_count > 0 ){
$str .= "
";
$str .= "
";
}
echo $str;
}
?>
";
$str .= "
";
$str .= " {$i}월
"; $str .= "";
$sql = "select * from g5_write_schedule_event where wr_1 > '{$month_this}' AND wr_1 < '{$month_next}' order by wr_1 asc";
$result = sql_query($sql);
for ($j=0; $row=sql_fetch_array($result); $j++) {
$sday = intval(substr($row['wr_1'],-2));
if( !trim($row['wr_2']) || $row['wr_1'] == $row['wr_2']){
$eday = "";
}else{
if( substr($row['wr_1'],-4,2) == substr($row['wr_2'],-4,2) )
$eday = "~". intval(substr($row['wr_2'],-2));
else
$eday = "~".intval(substr($row['wr_2'],-4,2))."/".intval(substr($row['wr_2'],-2));
}
$str .= "";
}
$str .= "
";
$str .= "