_content,
CONCAT(DATE_FORMAT(entry_start, '%Y.%m.%d'), ' ~ ', DATE_FORMAT(entry_end, '%Y.%m.%d')) entry,
read_count, comment_count, scrap_count,
CASE
WHEN entry_start > curdate() THEN '기간전'
WHEN entry_end > curdate() THEN DATEDIFF(entry_end, curdate())
WHEN entry_end = curdate() THEN '종료임박'
WHEN eval_start <= curdate() AND eval_end >= curdate() THEN '평가중'
ELSE '종료'
END d_day
FROM TB_CONTEST
WHERE del_yn = 'N'
AND confirm_yn = 'Y'
AND show_yn = 'Y'
AND gubun = 'T'
ORDER BY idx DESC ";
*/
$sql = "SELECT C.idx, poster_filename_thumb, contest_name, etc_content,
CONCAT(DATE_FORMAT(entry_start, '%Y.%m.%d'), ' ~ ', DATE_FORMAT(entry_end, '%Y.%m.%d')) entry,
read_count, comment_count, scrap_count,
CASE
WHEN entry_start > curdate() THEN '기간전'
WHEN entry_end > curdate() THEN DATEDIFF(entry_end, curdate())
WHEN entry_end = curdate() THEN '종료임박'
WHEN eval_start <= curdate() AND eval_end >= curdate() THEN '평가중'
ELSE '종료'
END d_day
FROM TB_CONTEST C
JOIN TB_THEME_CONTEST T ON C.idx = T.contest_idx
WHERE `status` = 'ENABLE'
AND start_date <= curdate()
AND end_date >= curdate()
AND del_yn = 'N'
AND confirm_yn = 'Y'
AND show_yn = 'Y'
AND gubun = 'T'
ORDER BY T.order ASC ";
$rs_theme = $db->Execute($sql);
//공지사항 가져오기 3줄
$sql = "SELECT idx, DATE_FORMAT(insert_date, '%Y-%m-%d') insert_date, title FROM board WHERE board_code = 'notice' AND del_yn = 'N' ORDER BY idx DESC LIMIT 0, 6 ";
$rs_notice = $db->Execute($sql);
//랭킹 가져오기 3명
$sql = "SELECT user_name, user_point
FROM TB_MEMBER
WHERE user_type = 'I'
AND del_yn = 'N'
AND user_level > 0
AND user_point > 0
ORDER BY user_point DESC
LIMIT 0,3 ";
$rs_rank = $db->Execute($sql);
//참여인원 가져오기
$sql = "SELECT COUNT(1) FROM TB_CONTEST_JOIN ";
$join_cnt = $db->GetOne($sql);
$db->close();
?>
Warning: include(../inc/header.php): failed to open stream: No such file or directory in /www_root/index.php on line 128
Warning: include(../inc/header.php): failed to open stream: No such file or directory in /www_root/index.php on line 128
Warning: include(): Failed opening '../inc/header.php' for inclusion (include_path='.:/usr/local/php56/lib/php') in /www_root/index.php on line 128
진행공모전 수 0
참여인원 수 0