wr_datetime 채택완료

</b>​</p><p>function this_year($skin_dir="", $bo_table, $rows=10, $subject_len=40, $options="")
{
    global $g4;</p><p>    if ($skin_dir)
        $latest_skin_path = "$g4[path]/skin/latest/$skin_dir";
    else
        $latest_skin_path = "$g4[path]/skin/latest/basic";</p><p>    $list = array();
 
  
    $sql = " select * from $g4[board_table] where bo_table = '$bo_table'";
    $board = sql_fetch($sql);</p><p>    $tmp_write_table = $g4['write_prefix'] . $bo_table; // 게시판 테이블 전체お名前
    //$sql = " select * from $tmp_write_table where wr_is_comment = 0 order by wr_id desc limit 0, $rows ";
    // 위의 코드 보다 속도가 빠름
 //$yearcheck = substr($g4[time_ymd], 0, 4)​;
 
 
 $chktime = substr($g4[time_ymdhis], 0, 4);
 
 //DATE_FORMAT(now(), '%Y-%m-%d %H:%i:%s')
 
 //$sql = " select * from $tmp_write_table where wr_is_comment = 0 and substr(wr_datetime,0,4) = substr(DATE_FORMAT(now(), '%Y-%m-%d %H:%i:%s'),0,4) order by wr_num limit 0, $rows "; 
 $sql = " select * from $tmp_write_table where wr_is_comment = 0 and wr_datetime > $chktime ​ order by wr_num limit 0, $rows "; 
 
 
   // $sql = " select * from $tmp_write_table where wr_is_comment = 0 order by wr_num limit 0, $rows ";
    //explain($sql);
    $result = sql_query($sql);
    for ($i=0; $row = sql_fetch_array($result); $i++) 
        //echo $row[wr_datetime];
  //echo  substr($row[wr_datetime],0,4);
  
  
  $list[$i] = get_list($row, $board, $latest_skin_path, $subject_len);
  
  
    
    ob_start();
    include "$latest_skin_path/latest.skin.php";
    $content = ob_get_contents();
    ob_end_clean();</p><p>    return $content;
} ​</p><p><b>