질문게시판 오류
질문게시판을 만들어서 쓰니깐 일케 뜹니다.
select count(*) as cnt from g4_write_03_2 where mb_id = 'admin' and wr_2 = '' and wr_is_comment = 0 and wr_datetime > adddate(curdate(), interval - day)
1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 5
error file : /onuri1.3/bbs/write.php
빌더는 오누리빌더요;;
select count(*) as cnt from g4_write_03_2 where mb_id = 'admin' and wr_2 = '' and wr_is_comment = 0 and wr_datetime > adddate(curdate(), interval - day)
1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 5
error file : /onuri1.3/bbs/write.php
빌더는 오누리빌더요;;
|
댓글을 작성하시려면 로그인이 필요합니다.
댓글 1개
As of MySQL 4.1.1, the second syntax is allowed. When invoked with the days form of the second argument, MySQL treats it as an integer number of days to be added to expr.
mysql 버젼이 4.1미만인가 봅니다.