에러 관련 하나 더 질문드립니다.. 정보
에러 관련 하나 더 질문드립니다..본문
게시판에 내글이랑 내 댓글 누르면 이런 에러가 뜨는데 왜 그런걸까요..
답변 부탁드려요..ㅠㅠ
select distinct wr_parent from g4_write_info 1 where (( mb_id = 'admin' ) ) and wr_is_comment = '0' and (wr_num between '' and '10000')
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 '1 where (( mb_id = 'admin' ) ) and wr_is_comment = '0' and (wr_num between '' ' at line 1
error file : /main/bbs/board.php
답변 부탁드려요..ㅠㅠ
select distinct wr_parent from g4_write_info 1 where (( mb_id = 'admin' ) ) and wr_is_comment = '0' and (wr_num between '' and '10000')
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 '1 where (( mb_id = 'admin' ) ) and wr_is_comment = '0' and (wr_num between '' ' at line 1
error file : /main/bbs/board.php
댓글 전체

select distinct wr_parent from g4_write_info where mb_id = 'admin' and wr_is_comment = '0' and ( wr_num between '' and '10000')
이 sql로 해보세요!
이 sql로 해보세요!
답변 감사합니다.
그런데 답변 처럼 어디쪽을 고쳐야 하는건가요..?
그런데 답변 처럼 어디쪽을 고쳐야 하는건가요..?