일정에 등록된 글 개수 추출

<?php$cday = 1;$sel_mon = sprintf("%02d",$month); $query = "SELECT * FROM $write_table WHERE left(wr_1,6) <= '$year$sel_mon' and left(wr_2,6) >= '$year$sel_mon' ORDER BY wr_id ASC";$result = sql_query($query);$j=0; // layer id// 내용을 보여주는 부분while ($row = sql_fetch_array($result)) {  // 제목글 뽑아서 링크 문자열 만들기..  if( substr($row[wr_1],0,6) <  $year.$sel_mon ) {  $start_day =1;   $start_day= (int)$start_day;  } else {  $start_day = substr($row[wr_1],6,2);     $start_day= (int)$start_day;  }  if( substr($row[wr_2],0,6) >  $year.$sel_mon ) {  $end_day = $lastday[$month];  $end_day= (int)$end_day;  } else {  $end_day = substr($row[wr_2],6,2);  $end_day= (int)$end_day;  }  // 아이디에 따라 다른 아이콘이미지 출력 하고 싶을때 ///주석을 해제  $imgown = 'icon';  for ($i = $start_day ; $i <= $end_day;  $i++) {    if (strlen($row[wr_3]) > 0) {  // 입력된 아이콘 값이 있을 때      $imgown = $row[wr_3] ; }    $j++; // layer ID    $list[comment_cnt] = " ".$row[wr_comment]; // row에 대하여 코멘트 카운터 정의    if($row[wr_comment] == 0) {      $list[comment_cnt] = null ;    } else {   if($list[comment_cnt]!=null) $list[comment_cnt] = "<b><font color=#ff6600>".$list[comment_cnt]."</font></b>";     }    $row[wr_subject] = cut_str(get_text($row[wr_subject]),$board[bo_subject_len],"…"); // subject length cut    $list['icon_new'] = ''; if ($row['wr_datetime'] >= date("Y-m-d H:i:s", G5_SERVER_TIME - ($board['bo_new'] * 3600)))      $list['icon_new'] = " <img src='$board_skin_url/img/icon_new.gif' align='absmiddle' alt='새글'>";    if ($member[mb_level] < $board[bo_read_level]) {      $showLayer="" ;    } else {       $showLayer=" onmouseover=\"PopupShow('".$j."')\" onmouseout=\"PopupHide('".$j."')\" ";    }    $html_day[$i].= "<br /><img src='$board_skin_url/img/".$imgown.".gif' border=0 align=absmiddle /> <a href='".G5_BBS_URL."/board.php?bo_table=$bo_table&year=$year&month=$month&wr_id=$row[wr_id]&sc_no=$sc_no' id='subject_".$j."' ".$showLayer.">".$row[wr_subject]."</a>".$list[icon_new].$list[comment_cnt];?>    <!-- 뷰 팝업레이어 -->    <DIV ID="popup_<?php echo $j ?>" class="popup_layer"> <?php    $html = 0;    if (strstr($row[wr_option], "html1"))      $html = 1;    else if (strstr($row[wr_option], "html2"))      $html = 2;      $viewlist = cut_str(conv_content($row[wr_content], $html),200,"…");   echo "( 작성자 : ".$row[wr_name]." )<br />";      echo $viewlist;?>    </DIV>