그룹별 바로가기 드롭메뉴 불량소스좀 봐주세요. 정보
질문 그룹별 바로가기 드롭메뉴 불량소스좀 봐주세요.관련링크
본문
40대 초보 플록입니다.
그룹별 보드별 제외 그룹과 제외 보드를 설정할 수 있는 드롭메뉴를 만들고 싶은데 그룹제외 부분이 잘 안됩니다!!
고수님 도와주세요~!!
아래 그룹제외 않되는 부분 입니다.
$sqlgr = " select * from $g4[group_table] order by gr_id ";//제외그룹 설정 않됨
//$sqlgr = " select * from $g4[group_table] where gr_id = '$rowgr[gr_id]'
//and gr_id not in ('test','','')
//order by gr_id ";
하위 보드제외는 되네요..
$resgr = sql_query($sqlgr);
while ($rowgr = mysql_fetch_array($resgr)) {
echo " <option>▒ $rowgr[gr_subject] ▒</option>";
$sqlbo = " select * from $g4[board_table] where gr_id = '$rowgr[gr_id]'
and bo_table not in ('skin_test','','')
order by bo_table ";
++++++++++++++++++++++++++++++++++++++전체소스++++++++++++++++++++++++++++++++++++++++
<!-- 플러그인 quickGo -->
<table width=100% height=100% cellpadding=2 cellspacing=0>
<tr>
<td align=center>
<!--Board quick-->
<script language='JavaScript'>
<!--
function change1(form) {
if(form.url.options[form.url.selectedIndex].value != "")
location.href=form.url.options[form.url.selectedIndex].value
}
//-->
</script>
<form name=quickgo>
<select name=url onChange=change1(this.form) size=0 STYLE="font-family:굴림; font-size:9pt; color:#000000; background-color:#FFFFFF; border-width:0; border-color:#eeeeee;">
<?
$sqlgr = " select * from $g4[group_table] order by gr_id ";//제외그룹 설정 않됨
//$sqlgr = " select * from $g4[group_table] where gr_id = '$rowgr[gr_id]'
//and gr_id not in ('test','','')
//order by gr_id ";
$resgr = sql_query($sqlgr);
while ($rowgr = mysql_fetch_array($resgr)) {
echo " <option>▒ $rowgr[gr_subject] ▒</option>";
$sqlbo = " select * from $g4[board_table] where gr_id = '$rowgr[gr_id]'
and bo_table not in ('skin_test','','')
order by bo_table ";
$resbo = sql_query($sqlbo);
while ($rowbo = mysql_fetch_array($resbo)) {
echo " <option value='$g4[bbs_path]/board.php?bo_table=$rowbo[bo_table]'> 》$rowbo[bo_subject]</option>";
}
mysql_free_result($resbo);
}
mysql_free_result($resgr);
?>
</select>
</td>
</tr></form>
</table>
<!-- 플러그인 quickGo end -->
그룹별 보드별 제외 그룹과 제외 보드를 설정할 수 있는 드롭메뉴를 만들고 싶은데 그룹제외 부분이 잘 안됩니다!!
고수님 도와주세요~!!
아래 그룹제외 않되는 부분 입니다.
$sqlgr = " select * from $g4[group_table] order by gr_id ";//제외그룹 설정 않됨
//$sqlgr = " select * from $g4[group_table] where gr_id = '$rowgr[gr_id]'
//and gr_id not in ('test','','')
//order by gr_id ";
하위 보드제외는 되네요..
$resgr = sql_query($sqlgr);
while ($rowgr = mysql_fetch_array($resgr)) {
echo " <option>▒ $rowgr[gr_subject] ▒</option>";
$sqlbo = " select * from $g4[board_table] where gr_id = '$rowgr[gr_id]'
and bo_table not in ('skin_test','','')
order by bo_table ";
++++++++++++++++++++++++++++++++++++++전체소스++++++++++++++++++++++++++++++++++++++++
<!-- 플러그인 quickGo -->
<table width=100% height=100% cellpadding=2 cellspacing=0>
<tr>
<td align=center>
<!--Board quick-->
<script language='JavaScript'>
<!--
function change1(form) {
if(form.url.options[form.url.selectedIndex].value != "")
location.href=form.url.options[form.url.selectedIndex].value
}
//-->
</script>
<form name=quickgo>
<select name=url onChange=change1(this.form) size=0 STYLE="font-family:굴림; font-size:9pt; color:#000000; background-color:#FFFFFF; border-width:0; border-color:#eeeeee;">
<?
$sqlgr = " select * from $g4[group_table] order by gr_id ";//제외그룹 설정 않됨
//$sqlgr = " select * from $g4[group_table] where gr_id = '$rowgr[gr_id]'
//and gr_id not in ('test','','')
//order by gr_id ";
$resgr = sql_query($sqlgr);
while ($rowgr = mysql_fetch_array($resgr)) {
echo " <option>▒ $rowgr[gr_subject] ▒</option>";
$sqlbo = " select * from $g4[board_table] where gr_id = '$rowgr[gr_id]'
and bo_table not in ('skin_test','','')
order by bo_table ";
$resbo = sql_query($sqlbo);
while ($rowbo = mysql_fetch_array($resbo)) {
echo " <option value='$g4[bbs_path]/board.php?bo_table=$rowbo[bo_table]'> 》$rowbo[bo_subject]</option>";
}
mysql_free_result($resbo);
}
mysql_free_result($resgr);
?>
</select>
</td>
</tr></form>
</table>
<!-- 플러그인 quickGo end -->
댓글 전체
제가 아는 것 하나도 없습니다.
다른 사람소스를 베낀 것입니다....아마 만도님이신 것 같은데....
다른 사람소스를 베낀 것입니다....아마 만도님이신 것 같은데....
morning님 대단히 감사합니다!
아래처럼 했습니다. 잘 됩니다.
// 제외시킬그룹 morning님께서 알려주셨습니다.
$sqlgr = " select * from $g4[group_table]
where gr_id <> '제외그룹1'
and gr_id <> '제외그룹2'
and gr_id <> '제외그룹3'
order by gr_id ";
$resgr = sql_query($sqlgr);
while ($rowgr = mysql_fetch_array($resgr)) {
echo " <option>▒ $rowgr[gr_subject] ▒</option>";
//제외시킬보드
$sqlbo = " select * from $g4[board_table]
where gr_id = '$rowgr[gr_id]'
and bo_table <> '제외보드1'
and bo_table <> '제외보드2'
order by bo_table ";
열심히 공부해야겠습니다.
아래처럼 했습니다. 잘 됩니다.
// 제외시킬그룹 morning님께서 알려주셨습니다.
$sqlgr = " select * from $g4[group_table]
where gr_id <> '제외그룹1'
and gr_id <> '제외그룹2'
and gr_id <> '제외그룹3'
order by gr_id ";
$resgr = sql_query($sqlgr);
while ($rowgr = mysql_fetch_array($resgr)) {
echo " <option>▒ $rowgr[gr_subject] ▒</option>";
//제외시킬보드
$sqlbo = " select * from $g4[board_table]
where gr_id = '$rowgr[gr_id]'
and bo_table <> '제외보드1'
and bo_table <> '제외보드2'
order by bo_table ";
열심히 공부해야겠습니다.
http://www.sir.co.kr/?doc=bbs/gnuboard.php&bo_table=qa&sselect=wr_subject&stext=%C6%AF%C1%A4&soperator=0&page=1&wr_id=21513
위 링크에 보면 자세히 나오더군요..
저는 님의 소스를 아래처럼 해보았습니다.
아주 좋습니다.
참고 http://cc.or.kr/ccc
---------------------
<table width=100% height=100% cellpadding=2 cellspacing=0>
<?
// $sqlgr = " select * from $g4[group_table]
// where gr_id <> 'way'
// and gr_id<>'gr_02' //제외시키려는 그룹을 이런식으로 추가
// order by gr_id ";
$sqlgr = " select * from $g4[group_table]
where gr_id <> '제외시킬그룹1'
and gr_id <> '제외시킬그룹2'
and gr_id <> '제외시킬그룹3'
order by gr_id ";
$resgr = sql_query($sqlgr);
while ($rowgr = mysql_fetch_array($resgr)) {
echo " <tr><td bgcolor='#F8F8F8' align=center> <a href=$g4[bbs_path]/group.php?gr_id=$rowgr[gr_id]>▒ ▒<b> $rowgr[gr_subject] </b>▒ ▒</a></td>
</tr>";
$sqlbo = " select * from $g4[board_table] where gr_id = '$rowgr[gr_id]' order by bo_table ";
$resbo = sql_query($sqlbo);
while ($rowbo = mysql_fetch_array($resbo)) {
echo " <tr><td> <a href=$g4[bbs_path]/board.php?bo_table=$rowbo[bo_table]><font size=1 color='#F07801'>† </font> $rowbo[bo_subject]</a></td></tr>";
}
mysql_free_result($resbo);
}
mysql_free_result($resgr);
?>
</table>
위 링크에 보면 자세히 나오더군요..
저는 님의 소스를 아래처럼 해보았습니다.
아주 좋습니다.
참고 http://cc.or.kr/ccc
---------------------
<table width=100% height=100% cellpadding=2 cellspacing=0>
<?
// $sqlgr = " select * from $g4[group_table]
// where gr_id <> 'way'
// and gr_id<>'gr_02' //제외시키려는 그룹을 이런식으로 추가
// order by gr_id ";
$sqlgr = " select * from $g4[group_table]
where gr_id <> '제외시킬그룹1'
and gr_id <> '제외시킬그룹2'
and gr_id <> '제외시킬그룹3'
order by gr_id ";
$resgr = sql_query($sqlgr);
while ($rowgr = mysql_fetch_array($resgr)) {
echo " <tr><td bgcolor='#F8F8F8' align=center> <a href=$g4[bbs_path]/group.php?gr_id=$rowgr[gr_id]>▒ ▒<b> $rowgr[gr_subject] </b>▒ ▒</a></td>
</tr>";
$sqlbo = " select * from $g4[board_table] where gr_id = '$rowgr[gr_id]' order by bo_table ";
$resbo = sql_query($sqlbo);
while ($rowbo = mysql_fetch_array($resbo)) {
echo " <tr><td> <a href=$g4[bbs_path]/board.php?bo_table=$rowbo[bo_table]><font size=1 color='#F07801'>† </font> $rowbo[bo_subject]</a></td></tr>";
}
mysql_free_result($resbo);
}
mysql_free_result($resgr);
?>
</table>