일정제목 리스트 갯수를 숫자로만 표기가 가능한가요? 채택완료

<div class="list-head div-head">
<span class="red">일요일</span>
<span>월요일</span>
<span>화요일</span>
<span>수요일</span>
<span>목요일</span>
<span>금요일</span>
<span class="blue">토요일</span>
</div>
<ul class="list-body">
<?php
$cday = 1;
$sel_mon = sprintf("%02d",$month);
$now_month = $year.$sel_mon;
$sca_sql = ($sca) ? "and ca_name = '".$sca."'" : "";
$result = sql_query("select * from $write_table where wr_is_comment = '0' and left(wr_1,6) <= '{$now_month}' and left(wr_2,6) >= '{$now_month}' $sca_sql order by wr_id asc");
while ($row = sql_fetch_array($result)) {

$start_day = (substr($row['wr_1'],0,6) < $now_month) ? 1 : substr($row['wr_1'],6,2);
$start_day= (int)$start_day;

$end_day = (substr($row['wr_2'],0,6) > $now_month) ? $lastday[$month] : substr($row['wr_2'],6,2);
$end_day= (int)$end_day;

$row2 = get_list($row, $board, $board_skin_url, G5_IS_MOBILE ? $board['bo_mobile_subject_len'] : $board['bo_subject_len']);

for ($i = $start_day; $i <= $end_day; $i++) {
$list[$i][] = $row2;
}
}

$temp = 7 - (($lastday[$month]+$dayoftheweek)%7);

if($temp == 7) $temp = 0;

$lastcount = $lastday[$month]+$dayoftheweek + $temp;

for ($iz = 1; $iz <= $lastcount; $iz++) {

$is_today = ($b_year == $year && $b_mon == $month && $b_day == $cday) ? true : false;

$daycolor = ' black';
$bg_daycolor = ' bg-black';

$dayweek = $iz%7;
if($dayweek == 1) {
echo '<li class="list-item">'.PHP_EOL;
$daycolor = ' red';
$bg_daycolor = ' bg-red';
} else if($dayweek == 0) {
$daycolor = ' blue';
$bg_daycolor = ' bg-blue';
}

$monthp = (strlen($month) == 1)? "0".$month:$month;
$cdayp = (strlen($cday) == 1)? "0".$cday:$cday;
$memday = $monthp.$cdayp;

$cf_anniversary = trim($wset['anniversary']);
$tooltip = '';
$bg_event = '';
$is_anniversary = false;
if ($cf_anniversary) {
$pattern = explode("\n", $cf_anniversary);
for ($s=0; $s<count($pattern); $s++) {

$anniversary = explode("|", $pattern[$s]);
if($anniversary[0] == $memday){
$daycolor = ($anniversary[2])?' '.$anniversary[2]:' red';
$tooltip = ' data-original-title="<nobr>'.$anniversary[1].'</nobr>" data-toggle="tooltip" data-placement="bottom" data-html="true"';
$is_anniversary = true;
$bg_event = ' bg-event';
}

}
}

//음력날짜
$myarray = soltolun($year,$month,$cday);

$daytext = ($is_today) ? '<span class="font-14 '.$tcolor.' en"><i class="fa fa-calendar-check-o fa-lg"></i> Today</span>' : $cday;

$do_cnt = count($list[$cday]);

if($dayoftheweek < $iz && $iz <= $lastday[$month]+$dayoftheweek) {
$fr_date = $year.sprintf("%02d",$month).sprintf("%02d",$cday);
?>
<div class="media<?php echo ($is_today) ? ' bg-today' : '';?> no-margin<?php echo $bg_event;?>">
<a class="media-date"<?php echo ($write_href) ? ' href="'.$write_href.'&amp;fr_date='.$fr_date.'&amp;to_date='.$fr_date.$sca_qstr.'"' : '';?>>
<span class="pull-left font-14 en<?php echo $daycolor;?>" <?php echo $tooltip;?>>
<span class="">
<?php echo $daytext;?>
</span>
<!--<span class="visible-xs"><?php// echo $month;?>.<?php// echo sprintf("%02d",$cday);?>(<?php// echo $yoil[$dayweek];?>)</span>-->
</span>
<?php if($is_lunar && ($is_today || $is_anniversary)){ ?><span class="pull-right black font-12"><?php echo $myarray['month'].'.'.$myarray['day'];?></span><?php } ?>
</a>
<?php if($do_cnt > 0) { ?>
<div class="media-body">
<ul class="do-list">
<?php for($i = 0; $i < $do_cnt; $i++) {
// 링크이동
$list[$cday][$i]['target'] = '';
if($is_link_target && $list[$cday][$i]['wr_link1']) {
$list[$cday][$i]['target'] = $is_link_target;
$list[$cday][$i]['href'] = $list[$cday][$i]['link_href'][1];
}
?>
<li>
<a href="<?php echo $list[$cday][$i]['href'];?>"<?php echo $list[$cday][$i]['target'];?><?php echo $is_modal_js;?>>
<span<?php echo ($list[$cday][$i]['wr_3']) ? ' class="'.$list[$cday][$i]['wr_3'].'"' : '';?>>
<?php echo apms_fa($list[$cday][$i]['as_icon']);?>
<?php echo $list[$cday][$i]['subject'] ;?>
</span>
<?php if($list[$cday][$i]['wr_comment']) { ?>
<span class="count orangered"><?php echo $list[$cday][$i]['wr_comment'];?></span>
<?php } ?>
</a>
</li>
<?php } ?>
</ul>
</div>
<?php } ?>
</div>
<?php
$cday++;
} else {
echo '<div class=""></div>'.PHP_EOL;
}

if($iz%7 == 0) echo '</li>'.PHP_EOL;
}
?>
</ul>

[code]
<div class="list-head div-head">
<span class="red">일요일</span>
<span>월요일</span>
<span>화요일</span>
<span>수요일</span>
<span>목요일</span>
<span>금요일</span>
<span class="blue">토요일</span>
</div>
<ul class="list-body">
<?php
$cday = 1;
$sel_mon = sprintf("%02d",$month);
$now_month = $year.$sel_mon;
$sca_sql = ($sca) ? "and ca_name = '".$sca."'" : "";
$result = sql_query("select * from $write_table where wr_is_comment = '0' and left(wr_1,6) <= '{$now_month}' and left(wr_2,6) >= '{$now_month}' $sca_sql order by wr_id asc");
while ($row = sql_fetch_array($result)) {

$start_day = (substr($row['wr_1'],0,6) < $now_month) ? 1 : substr($row['wr_1'],6,2);
$start_day= (int)$start_day;

$end_day = (substr($row['wr_2'],0,6) > $now_month) ? $lastday[$month] : substr($row['wr_2'],6,2);
$end_day= (int)$end_day;

$row2 = get_list($row, $board, $board_skin_url, G5_IS_MOBILE ? $board['bo_mobile_subject_len'] : $board['bo_subject_len']);

for ($i = $start_day; $i <= $end_day; $i++) {
$list[$i][] = $row2;
}
}

$temp = 7 - (($lastday[$month]+$dayoftheweek)%7);

if($temp == 7) $temp = 0;

$lastcount = $lastday[$month]+$dayoftheweek + $temp;

for ($iz = 1; $iz <= $lastcount; $iz++) {

$is_today = ($b_year == $year && $b_mon == $month && $b_day == $cday) ? true : false;

$daycolor = ' black';
$bg_daycolor = ' bg-black';

$dayweek = $iz%7;
if($dayweek == 1) {
echo '<li class="list-item">'.PHP_EOL;
$daycolor = ' red';
$bg_daycolor = ' bg-red';
} else if($dayweek == 0) {
$daycolor = ' blue';
$bg_daycolor = ' bg-blue';
}

$monthp = (strlen($month) == 1)? "0".$month:$month;
$cdayp = (strlen($cday) == 1)? "0".$cday:$cday;
$memday = $monthp.$cdayp;

$cf_anniversary = trim($wset['anniversary']);
$tooltip = '';
$bg_event = '';
$is_anniversary = false;
if ($cf_anniversary) {
$pattern = explode("\n", $cf_anniversary);
for ($s=0; $s<count($pattern); $s++) {

$anniversary = explode("|", $pattern[$s]);
if($anniversary[0] == $memday){
$daycolor = ($anniversary[2])?' '.$anniversary[2]:' red';
$tooltip = ' data-original-title="<nobr>'.$anniversary[1].'</nobr>" data-toggle="tooltip" data-placement="bottom" data-html="true"';
$is_anniversary = true;
$bg_event = ' bg-event';
}

}
}

//음력날짜
$myarray = soltolun($year,$month,$cday);

$daytext = ($is_today) ? '<span class="font-14 '.$tcolor.' en"><i class="fa fa-calendar-check-o fa-lg"></i> Today</span>' : $cday;

$do_cnt = count($list[$cday]);

if($dayoftheweek < $iz && $iz <= $lastday[$month]+$dayoftheweek) {
$fr_date = $year.sprintf("%02d",$month).sprintf("%02d",$cday);
?>
<div class="media<?php echo ($is_today) ? ' bg-today' : '';?> no-margin<?php echo $bg_event;?>">
<a class="media-date"<?php echo ($write_href) ? ' href="'.$write_href.'&amp;fr_date='.$fr_date.'&amp;to_date='.$fr_date.$sca_qstr.'"' : '';?>>
<span class="pull-left font-14 en<?php echo $daycolor;?>" <?php echo $tooltip;?>>
<span class="">
<?php echo $daytext;?>
</span>
<!--<span class="visible-xs"><?php// echo $month;?>.<?php// echo sprintf("%02d",$cday);?>(<?php// echo $yoil[$dayweek];?>)</span>-->
</span>
<?php if($is_lunar && ($is_today || $is_anniversary)){ ?><span class="pull-right black font-12"><?php echo $myarray['month'].'.'.$myarray['day'];?></span><?php } ?>
</a>
<?php /*if($do_cnt > 0) { ?>
<div class="media-body">
<ul class="do-list">
<?php for($i = 0; $i < $do_cnt; $i++) {
// 링크이동
$list[$cday][$i]['target'] = '';
if($is_link_target && $list[$cday][$i]['wr_link1']) {
$list[$cday][$i]['target'] = $is_link_target;
$list[$cday][$i]['href'] = $list[$cday][$i]['link_href'][1];
}
?>
<li>
<a href="<?php echo $list[$cday][$i]['href'];?>"<?php echo $list[$cday][$i]['target'];?><?php echo $is_modal_js;?>>
<span<?php echo ($list[$cday][$i]['wr_3']) ? ' class="'.$list[$cday][$i]['wr_3'].'"' : '';?>>
<?php echo apms_fa($list[$cday][$i]['as_icon']);?>
<?php echo $list[$cday][$i]['subject'] ;?>
</span>
<?php if($list[$cday][$i]['wr_comment']) { ?>
<span class="count orangered"><?php echo $list[$cday][$i]['wr_comment'];?></span>
<?php } ?>
</a>
</li>
<?php } ?>
</ul>
</div>
<?php } */?>
<?php if($do_cnt > 0) { ?>
<div class="media-body">
<ul class="do-list">
<li><?php echo $do_cnt; ?></li>
</ul>
</div>
<?php } ?>
</div>
<?php
$cday++;
} else {
echo '<div class=""></div>'.PHP_EOL;
}

if($iz%7 == 0) echo '</li>'.PHP_EOL;
}
?>
</ul>
[/code]

주석 처리할 부분을 혼동했네요. 수정하였습니다.

아아. 감사합니다. 숫자 클릭하면 게시글로 이동시는 아까 링크부분 살려두면되는지요??

select count(*) from ddd1 where wr_iscomment = 0 and 날짜조건
이런식으로 하셔서 나온 카운트를 어느곳에 넣어야 되는지요? ㅠ 초보라 여간 어렵네요.

<?php$sql ="select count(wr_subject) as cnt, wr_subject from ddd1 where wr_is_comment = 0 and mb_id = 'mb_id' group by wr_subject"; // 제목별로 갯수를 구하는 쿼리문
$result = sql_query($sql);
?>