게시판 안에서 검색이 안되요..좀도와주세요. 정보
게시판 안에서 검색이 안되요..좀도와주세요.본문
기존에는 슬라이드로 내려오는데 그제목이런걸 체크할수있게끔 뺐는데요... 오류가 나네요..ㅠㅠ
<table width="100%" align="center" cellpadding="0" cellspacing="0"><tr><td>
<!-- 검색 -->
<tr bgcolor="#f5f5f5">
<br>
<div class="board_search">
<form name="fsearch" method="get">
<input type="hidden" name="bo_table" value="<?=$bo_table?>">
<input type="hidden" name="sca" value="<?=$sca?>">
<form name="sfl">
<input type="checkbox" name="wr_subject" value="wr_subject">제목
<input type="checkbox" name="wr_content" value="wr_content">내용
<input type="checkbox" name="wr_name,1" value="wr_subject">글쓴이
<input name="stx" class="stx" maxlength="15" itemname="검색어" required value='<?=$stx?>'>
<input type="image" src="<?=$board_skin_path?>/img/btn_search.gif" border='0' align="absmiddle">
<p>
</form></form>
</div>
</tr>
</table>
</td></tr></table>
검색하면 아래와 같이 이렇게 나오는데 왜그러죠?
select distinct wr_parent from g4_write_basic2 where ((INSTR(, '.')) ) and (wr_num between '-1' and '9999')
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 '-1' and '9999')' at line 1
error file : /bbs/board.php
<table width="100%" align="center" cellpadding="0" cellspacing="0"><tr><td>
<!-- 검색 -->
<tr bgcolor="#f5f5f5">
<br>
<div class="board_search">
<form name="fsearch" method="get">
<input type="hidden" name="bo_table" value="<?=$bo_table?>">
<input type="hidden" name="sca" value="<?=$sca?>">
<form name="sfl">
<input type="checkbox" name="wr_subject" value="wr_subject">제목
<input type="checkbox" name="wr_content" value="wr_content">내용
<input type="checkbox" name="wr_name,1" value="wr_subject">글쓴이
<input name="stx" class="stx" maxlength="15" itemname="검색어" required value='<?=$stx?>'>
<input type="image" src="<?=$board_skin_path?>/img/btn_search.gif" border='0' align="absmiddle">
<p>
</form></form>
</div>
</tr>
</table>
</td></tr></table>
검색하면 아래와 같이 이렇게 나오는데 왜그러죠?
select distinct wr_parent from g4_write_basic2 where ((INSTR(, '.')) ) and (wr_num between '-1' and '9999')
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 '-1' and '9999')' at line 1
error file : /bbs/board.php
댓글 전체
예제)
<form name="fsearch" method="get">
<input type="hidden" name="bo_table" value="<?=$bo_table?>">
<input type="hidden" name="sca" value="<?=$sca?>">
<select name="sfl">
<option value="wr_subject">제목</option>
<option value="wr_content">내용</option>
<option value="wr_subject||wr_content">제목+내용</option>
<option value="mb_id,1">회원아이디</option>
<option value="mb_id,0">회원아이디(코)</option>
<option value="wr_name,1">글쓴이</option>
<option value="wr_name,0">글쓴이(코)</option>
</select>
<input name="stx" class="stx" maxlength="15" itemname="검색어" required value='<?=stripslashes($stx)?>'>
<input type="image" src="<?=$board_skin_path?>/img/btn_search.gif" border='0' align="absmiddle">
<input type="radio" name="sop" value="and">and
<input type="radio" name="sop" value="or">or
</form>
<form name="fsearch" method="get">
<input type="hidden" name="bo_table" value="<?=$bo_table?>">
<input type="hidden" name="sca" value="<?=$sca?>">
<select name="sfl">
<option value="wr_subject">제목</option>
<option value="wr_content">내용</option>
<option value="wr_subject||wr_content">제목+내용</option>
<option value="mb_id,1">회원아이디</option>
<option value="mb_id,0">회원아이디(코)</option>
<option value="wr_name,1">글쓴이</option>
<option value="wr_name,0">글쓴이(코)</option>
</select>
<input name="stx" class="stx" maxlength="15" itemname="검색어" required value='<?=stripslashes($stx)?>'>
<input type="image" src="<?=$board_skin_path?>/img/btn_search.gif" border='0' align="absmiddle">
<input type="radio" name="sop" value="and">and
<input type="radio" name="sop" value="or">or
</form>
