쿼리 질문요...ㅜㅡ 정보
그누보드 쿼리 질문요...ㅜㅡ본문
<?
define("_DOCTYPE_", "DESIGN");
$re_01_001 = mysql_fetch_array(mysql_query(" select count(*) from gb_write_001 where wr_datetime like '%2004-01%'", $connect));
$re_01_002 = mysql_fetch_array(mysql_query(" select count(*) from gb_write_002 where wr_datetime like '%2004-01%'", $connect));
$re_01_003 = mysql_fetch_array(mysql_query(" select count(*) from gb_write_003 where wr_datetime like '%2004-01%'", $connect));
$re_01_101 = mysql_fetch_array(mysql_query(" select count(*) from gb_write_101 where wr_datetime like '%2004-01%'", $connect));
$re_01_102 = mysql_fetch_array(mysql_query(" select count(*) from gb_write_102 where wr_datetime like '%2004-01%'", $connect));
$re_01_103 = mysql_fetch_array(mysql_query(" select count(*) from gb_write_103 where wr_datetime like '%2004-01%'", $connect));
$re_01_201 = mysql_fetch_array(mysql_query(" select count(*) from gb_write_201 where wr_datetime like '%2004-01%'", $connect));
$re_01_202 = mysql_fetch_array(mysql_query(" select count(*) from gb_write_202 where wr_datetime like '%2004-01%'", $connect));
$re_01_203 = mysql_fetch_array(mysql_query(" select count(*) from gb_write_203 where wr_datetime like '%2004-01%'", $connect));
$re_01_204 = mysql_fetch_array(mysql_query(" select count(*) from gb_write_204 where wr_datetime like '%2004-01%'", $connect));
$re_01_205 = mysql_fetch_array(mysql_query(" select count(*) from gb_write_205 where wr_datetime like '%2004-01%'", $connect));
$re_01_tot = $re_01_001 + $re_01_002 + $re_01_003 + $re_01_101 + $re_01_102 + $re_01_103 + $re_01_201 + $re_01_202 + $re_01_203 + $re_01_204 + $re_01_205 ;
?>
이렇게 쿼리를 돌리는데요....
각 게시판 별로 1월에 쓴 글수만 몇개인지 뽑아오려고 하거든요...
근데....이걸 저장해서 익스플로어로 불러오면 아무값도 안나오네요...
하다못해 0이라도 나와야 되는거 아닌가요??
고수님들 수정좀 해주세요....부탁합니다..
아참..하나더요...
_DOCTYPE_ 오류 : NONE , STYLE , DESIGN 중 하나를 사용하세요.
이런 메세지가 뜨거든요.....
저는 맨위에다가 분명히 써주었는데도 메세지가 나오네요...뭐가 잘못된건지??
define("_DOCTYPE_", "DESIGN");
$re_01_001 = mysql_fetch_array(mysql_query(" select count(*) from gb_write_001 where wr_datetime like '%2004-01%'", $connect));
$re_01_002 = mysql_fetch_array(mysql_query(" select count(*) from gb_write_002 where wr_datetime like '%2004-01%'", $connect));
$re_01_003 = mysql_fetch_array(mysql_query(" select count(*) from gb_write_003 where wr_datetime like '%2004-01%'", $connect));
$re_01_101 = mysql_fetch_array(mysql_query(" select count(*) from gb_write_101 where wr_datetime like '%2004-01%'", $connect));
$re_01_102 = mysql_fetch_array(mysql_query(" select count(*) from gb_write_102 where wr_datetime like '%2004-01%'", $connect));
$re_01_103 = mysql_fetch_array(mysql_query(" select count(*) from gb_write_103 where wr_datetime like '%2004-01%'", $connect));
$re_01_201 = mysql_fetch_array(mysql_query(" select count(*) from gb_write_201 where wr_datetime like '%2004-01%'", $connect));
$re_01_202 = mysql_fetch_array(mysql_query(" select count(*) from gb_write_202 where wr_datetime like '%2004-01%'", $connect));
$re_01_203 = mysql_fetch_array(mysql_query(" select count(*) from gb_write_203 where wr_datetime like '%2004-01%'", $connect));
$re_01_204 = mysql_fetch_array(mysql_query(" select count(*) from gb_write_204 where wr_datetime like '%2004-01%'", $connect));
$re_01_205 = mysql_fetch_array(mysql_query(" select count(*) from gb_write_205 where wr_datetime like '%2004-01%'", $connect));
$re_01_tot = $re_01_001 + $re_01_002 + $re_01_003 + $re_01_101 + $re_01_102 + $re_01_103 + $re_01_201 + $re_01_202 + $re_01_203 + $re_01_204 + $re_01_205 ;
?>
이렇게 쿼리를 돌리는데요....
각 게시판 별로 1월에 쓴 글수만 몇개인지 뽑아오려고 하거든요...
근데....이걸 저장해서 익스플로어로 불러오면 아무값도 안나오네요...
하다못해 0이라도 나와야 되는거 아닌가요??
고수님들 수정좀 해주세요....부탁합니다..
아참..하나더요...
_DOCTYPE_ 오류 : NONE , STYLE , DESIGN 중 하나를 사용하세요.
이런 메세지가 뜨거든요.....
저는 맨위에다가 분명히 써주었는데도 메세지가 나오네요...뭐가 잘못된건지??
댓글 전체