검색 폼을 만들고있는데요 검색이 안되네요 고수님들 한번만 봐주세요 정보
검색 폼을 만들고있는데요 검색이 안되네요 고수님들 한번만 봐주세요본문
<form name='f2' >
<table width="634" border="0" cellspacing="0" cellpadding="0" class="column_search">
<tr height="55">
<td align="center">
<table width="600" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="90"><strong class="sarea">검색범위</strong></td>
<td><input type="checkbox" class="etc" name="encry_all" value="all" onClick="checkAll(this.checked,entry_price);">전체
<input type="checkbox" id="entry_price" name="encry_title" value="title">제목
<input type="checkbox" id="entry_price" name="encry_contents" value="contents">내용
</td>
<td width="180"><input type="text" name="stx" value="<?=$stx?>" style="width:170px;" /></td>
<td width="80"><a href="#" onclick='search_exe();'><img src="../images/board/column_search_btn.gif"></a></td>
</tr>
</table>
</td>
</tr>
</table>
</form>
이렇게 폼을 날렸구요
위에서
function search_exe(){
var frm = document.f2;
frm.action = 'column_list.php';
frm.method='get';
frm.submit();
}
이렇게 받아서
$Query = "select title,register_date,view_count from board where category_seq=11 ";
if($encry_all == "all"){
$Query =$Query.=" and title like '%$stx%' or contents like '%$stx%'";
echo $encry_price;
echo $stx;
}
if($encry_title == "title"){
$Query =$Query .=" and title like '%$stx%'";
echo $encry_price;
echo $stx;
}
if($encry_contents == "contents"){
$Query =$Query .=" and contents like '%$stx%'";
echo $encry_price;
echo $stx;
}
$Query1 = mysql_query($Query .="ORDER BY board_seq DESC limit $START_NUM,$RECNUM",$db);
이러게 쿼리를 날립니다
그리고 밑에서
<?
while($row=mysql_fetch_array($Query1)){
?>
<tbody>
<tr height="32">
<td align="center">97</td>
<td class="link"><a href="javascript:open_view(<?=$row['board_seq'];?>)"><?=iconv("UTF-8", "EUC-KR", $row['title']);?></a></td>
<td align="center"><?=$row['register_date'];?></td>
<td align="center"><?=$row['view_count'];?></td>
</tr>
<?
}
?>
이렇게 뿌려주고요
전부한페이지에서 처리합니다
어디가 문제인지 도저히 모르겠네요
쿼리를 날리면 값은 제대로 넘어가거든요
select title,register_date,view_count from board where category_seq=11 and title like '%연세%'ORDER BY board_seq DESC limit 0,20 이렇게 넘어가는데
페이지에 뿌려지질 않네요...
<table width="634" border="0" cellspacing="0" cellpadding="0" class="column_search">
<tr height="55">
<td align="center">
<table width="600" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="90"><strong class="sarea">검색범위</strong></td>
<td><input type="checkbox" class="etc" name="encry_all" value="all" onClick="checkAll(this.checked,entry_price);">전체
<input type="checkbox" id="entry_price" name="encry_title" value="title">제목
<input type="checkbox" id="entry_price" name="encry_contents" value="contents">내용
</td>
<td width="180"><input type="text" name="stx" value="<?=$stx?>" style="width:170px;" /></td>
<td width="80"><a href="#" onclick='search_exe();'><img src="../images/board/column_search_btn.gif"></a></td>
</tr>
</table>
</td>
</tr>
</table>
</form>
이렇게 폼을 날렸구요
위에서
function search_exe(){
var frm = document.f2;
frm.action = 'column_list.php';
frm.method='get';
frm.submit();
}
이렇게 받아서
$Query = "select title,register_date,view_count from board where category_seq=11 ";
if($encry_all == "all"){
$Query =$Query.=" and title like '%$stx%' or contents like '%$stx%'";
echo $encry_price;
echo $stx;
}
if($encry_title == "title"){
$Query =$Query .=" and title like '%$stx%'";
echo $encry_price;
echo $stx;
}
if($encry_contents == "contents"){
$Query =$Query .=" and contents like '%$stx%'";
echo $encry_price;
echo $stx;
}
$Query1 = mysql_query($Query .="ORDER BY board_seq DESC limit $START_NUM,$RECNUM",$db);
이러게 쿼리를 날립니다
그리고 밑에서
<?
while($row=mysql_fetch_array($Query1)){
?>
<tbody>
<tr height="32">
<td align="center">97</td>
<td class="link"><a href="javascript:open_view(<?=$row['board_seq'];?>)"><?=iconv("UTF-8", "EUC-KR", $row['title']);?></a></td>
<td align="center"><?=$row['register_date'];?></td>
<td align="center"><?=$row['view_count'];?></td>
</tr>
<?
}
?>
이렇게 뿌려주고요
전부한페이지에서 처리합니다
어디가 문제인지 도저히 모르겠네요
쿼리를 날리면 값은 제대로 넘어가거든요
select title,register_date,view_count from board where category_seq=11 and title like '%연세%'ORDER BY board_seq DESC limit 0,20 이렇게 넘어가는데
페이지에 뿌려지질 않네요...
댓글 전체
그누보드에 맞춰 코딩해봤는데요..잘되는데요
아래가 column_list.php입니다
<?
include_once"./dbconnect.php"; //데이터베이스 컨넥션
$Query = "select wr_subject,wr_datetime,wr_hit from 테이블where wr_id !='' ";
if($encry_all == "all"){
$Query =$Query.=" and wr_subject like '%$stx%' or wr_content like '%$stx%'";
echo "$encry_price";
echo "$stx";
}
if($encry_wr_subject == "wr_subject"){
$Query =$Query .=" and wr_subject like '%$stx%'";
echo $encry_price;
echo $stx;
}
if($encry_wr_content == "wr_content"){
$Query =$Query .=" and wr_content like '%$stx%'";
echo $encry_price;
echo $stx;
}
$Query1 = mysql_query($Query .="ORDER BY wr_id DESC limit 0,20",$connect_db);
?>
<?
while($row=mysql_fetch_array($Query1)){
?>
<tbody>
<tr height="32">
<td align="center">97</td>
<td class="link"><a href="javascript:open_view(<?=$row['board_seq'];?>)"><?=iconv("UTF-8", "EUC-KR", $row['wr_subject']);?></a></td>
<td align="center"><?=$row['wr_datetime'];?></td>
<td align="center"><?=$row['wr_hit'];?></td>
</tr>
<?
}
?>
잘되고요..
혹시 --> select title,register_date,view_count from board where category_seq=11 and title like '%연세%'ORDER BY board_seq DESC limit 0,20 여기에서 연세%'ORDER <-- 이렇게 붙어서 그런거 아닌가요..?? 연세%' ORDER 이렇게 말이죠
아래가 column_list.php입니다
<?
include_once"./dbconnect.php"; //데이터베이스 컨넥션
$Query = "select wr_subject,wr_datetime,wr_hit from 테이블where wr_id !='' ";
if($encry_all == "all"){
$Query =$Query.=" and wr_subject like '%$stx%' or wr_content like '%$stx%'";
echo "$encry_price";
echo "$stx";
}
if($encry_wr_subject == "wr_subject"){
$Query =$Query .=" and wr_subject like '%$stx%'";
echo $encry_price;
echo $stx;
}
if($encry_wr_content == "wr_content"){
$Query =$Query .=" and wr_content like '%$stx%'";
echo $encry_price;
echo $stx;
}
$Query1 = mysql_query($Query .="ORDER BY wr_id DESC limit 0,20",$connect_db);
?>
<?
while($row=mysql_fetch_array($Query1)){
?>
<tbody>
<tr height="32">
<td align="center">97</td>
<td class="link"><a href="javascript:open_view(<?=$row['board_seq'];?>)"><?=iconv("UTF-8", "EUC-KR", $row['wr_subject']);?></a></td>
<td align="center"><?=$row['wr_datetime'];?></td>
<td align="center"><?=$row['wr_hit'];?></td>
</tr>
<?
}
?>
잘되고요..
혹시 --> select title,register_date,view_count from board where category_seq=11 and title like '%연세%'ORDER BY board_seq DESC limit 0,20 여기에서 연세%'ORDER <-- 이렇게 붙어서 그런거 아닌가요..?? 연세%' ORDER 이렇게 말이죠
답변감사합니다
아주 이거 떄문에 머리가 아파죽겠습니다
아직 해결못했네요 ㅠㅠ
아주 이거 떄문에 머리가 아파죽겠습니다
아직 해결못했네요 ㅠㅠ