아래와 같은 통합검색 소스를 이용하고 있는데 제외그룹 설정하려면 어찌하면 되나요 정보
아래와 같은 통합검색 소스를 이용하고 있는데 제외그룹 설정하려면 어찌하면 되나요본문
<table width="100%" height="32" cellspacing="0" cellpadding="0" align="right">
<form name="fsearchbox" method="get" action="javascript:fsearchbox_submit(document.fsearchbox);">
<input type="hidden" name="sfl" value="wr_subject">
<input type="hidden" name="sop" value="and">
<tr>
<td width="5"></td>
<td width="90" align="center" style="padding-top:1px;">
<?
$group_select = "<select id='gr_id' name='gr_id'><option value=''>통합검색 ▒";
$sql = " select gr_id, gr_subject from $g4[group_table] order by gr_id ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++)
$group_select .= "<option value='$row[gr_id]'>$row[gr_subject]";
$group_select .= "</select>";
?>
<?=$group_select?>
</td>
<td width="5"></td>
<td width="120" valign="middle" align="right">
<input name="stx" maxlength="40" class="text_box" tabindex="1"></td>
<td width="5"></td>
<td width="51" align="right">
<input type="image" src="<?=$gnusr[img_btn]?>/btn_search.gif" width="39" height="20" border="0"></td>
<td width="4"></td>
</tr>
</form>
</table>
</td>
<td width="20" height="62">
<img src="<?=$gnusr[img]?>/index_search_03.gif" width="20" height="62" alt=""></td>
</tr>
</table>
<form name="fsearchbox" method="get" action="javascript:fsearchbox_submit(document.fsearchbox);">
<input type="hidden" name="sfl" value="wr_subject">
<input type="hidden" name="sop" value="and">
<tr>
<td width="5"></td>
<td width="90" align="center" style="padding-top:1px;">
<?
$group_select = "<select id='gr_id' name='gr_id'><option value=''>통합검색 ▒";
$sql = " select gr_id, gr_subject from $g4[group_table] order by gr_id ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++)
$group_select .= "<option value='$row[gr_id]'>$row[gr_subject]";
$group_select .= "</select>";
?>
<?=$group_select?>
</td>
<td width="5"></td>
<td width="120" valign="middle" align="right">
<input name="stx" maxlength="40" class="text_box" tabindex="1"></td>
<td width="5"></td>
<td width="51" align="right">
<input type="image" src="<?=$gnusr[img_btn]?>/btn_search.gif" width="39" height="20" border="0"></td>
<td width="4"></td>
</tr>
</form>
</table>
</td>
<td width="20" height="62">
<img src="<?=$gnusr[img]?>/index_search_03.gif" width="20" height="62" alt=""></td>
</tr>
</table>
댓글 전체
<?
$group_select = "<select id='gr_id' name='gr_id'><option value=''>통합검색 ▒";
$sql = " select gr_id, gr_subject from $g4[group_table] order by gr_id ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++)
$group_select .= "<option value='$row[gr_id]'>$row[gr_subject]";
$group_select .= "</select>";
?>
==>
<?
$group_select = "<select id='gr_id' name='gr_id'><option value=''>통합검색 ▒";
$sql = " select gr_id, gr_subject from $g4[group_table] where gr_id <> '제외그룹1' and gr_id <> '제외그룹2' order by gr_id ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++)
$group_select .= "<option value='$row[gr_id]'>$row[gr_subject]";
$group_select .= "</select>";
?>
수정 부분 참고하시어 추가하시면 됩니다...
$group_select = "<select id='gr_id' name='gr_id'><option value=''>통합검색 ▒";
$sql = " select gr_id, gr_subject from $g4[group_table] order by gr_id ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++)
$group_select .= "<option value='$row[gr_id]'>$row[gr_subject]";
$group_select .= "</select>";
?>
==>
<?
$group_select = "<select id='gr_id' name='gr_id'><option value=''>통합검색 ▒";
$sql = " select gr_id, gr_subject from $g4[group_table] where gr_id <> '제외그룹1' and gr_id <> '제외그룹2' order by gr_id ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++)
$group_select .= "<option value='$row[gr_id]'>$row[gr_subject]";
$group_select .= "</select>";
?>
수정 부분 참고하시어 추가하시면 됩니다...
천상재회님// 감사합니다.. 잘되네요