검색폼에서 오류내용좀 알려주세요 정보
검색폼에서 오류내용좀 알려주세요본문
검색어를 넣고 검색하다가 이런 경우가 나오면, 어느부분이 잘못된거에요?
오류내용
select distinct wr_parent from g4_write_test7 where stx = '진행' and ((INSTR(, '진행')) ) and (wr_num between '-17' and '9983')
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 ' '진행')) ) and (wr_num between '-17' and '9983')' at line 1
error file : /bbs/board.php
오류내용
select distinct wr_parent from g4_write_test7 where stx = '진행' and ((INSTR(, '진행')) ) and (wr_num between '-17' and '9983')
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 ' '진행')) ) and (wr_num between '-17' and '9983')' at line 1
error file : /bbs/board.php
댓글 전체
INSTR(필드명, '진행')
<form 쪽이 문제인듯....
감사합니다.