하루전, 하루후 등 게시물 검색하기

mktime() 하루전, 하루후 등 게시물 검색하기
 $yday   = date("m-d-Y",strtotime("-1 day", time()));
 $yday   = split("-", $yday);
 $ydays  = mktime(0,0,0,$yday[0],$yday[1],$yday[2]);

*.전체 참여자 수 계산
function all_record_cnt($tbname){
 $sql    = "select count(*) from $tbname";
 $result = mysql_query($sql);
 $cnt    = mysql_result($result, 0, 0);
 return $cnt;
}
*.어제 참여자 수 계산
function yday_record_cnt($tbname){
 $yday   = date("m-d-Y",strtotime("-1 day", time()));
 $yday   = split("-", $yday);
 $ydays  = mktime(0,0,0,$yday[0],$yday[1],$yday[2]);
 $ydaye  = mktime(23,59,59,$yday[0],$yday[1],$yday[2]);
 $sql    = "select count(*) from $tbname ";
 $sql   .= "where write_day>='$ydays' and write_day<='$ydaye'";
 $result = mysql_query($sql);
 $cnt    = mysql_result($result, 0, 0);
 return $cnt;
}
*.오늘 참여자 수 계산
function tday_record_cnt($tbname){
 $tday   = date("m-d-Y");
 $tday   = split("-", $tday);
 $tdays  = mktime(0,0,0,$tday[0],$tday[1],$tday[2]);
 $tdaye  = mktime(23,59,59,$tday[0],$tday[1],$tday[2]);
 $sql    = "select count(*) from $tbname ";
 $sql   .= "where write_day>='$tdays' and write_day<='$tdaye'";
 $result = mysql_query($sql);
 $cnt    = mysql_result($result, 0, 0);
 return $cnt;
}

참고 사이트 : http://www.freeimage.kr/bbs/board.php?bo_table=tip_php&wr_id=329&stx=&sst=wr_hit&sod=desc&sop=and&page=13