자동그룹메뉴중 링크를 게시판으로 지정하기 정보
자동그룹메뉴중 링크를 게시판으로 지정하기본문
<ul>
<?
$sql = " select gr_id, gr_subject from $g4[group_table] order by gr_1+1 ";
$result = sql_query($sql);
while ($row=mysql_fetch_array($result)) {
if ($row[gr_id] == $gr_id) {
echo "<li id=current><a href=$g4[bbs_path]/group.php?gr_id=$row[gr_id]><b>$row[gr_subject] </b></a></li>"; }
else {
echo "<li><a href=$g4[bbs_path]/group.php?gr_id=$row[gr_id]><b>$row[gr_subject]</b></a></li>"; }
}
?>
</ul>
</div>
위소스를 헤드에 넣어 그룹을 호출하고 있습니다.
가령 1번그룹을 클릭시 지정 게시판으로 가게 하려면 else구문을 어떻게 넣어야 할까요? ㅠㅜ
( select a.* , ( select sum(co_count) as co_count from g4_qa_choose where mb_id=a.mb_id and bo_table = 'g4_qa' ) as q_co_count from `g4_write_g4_qa` a where wr_parent = '171552' and wr_8 != '' and wr_is_comment = 1 and CONVERT(wr_7, UNSIGNED) >= 5 group by wr_content having max(wr_7) order by CONVERT(wr_7, UNSIGNED) desc limit 3 )
1055 : Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sir.a.wr_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
error file : /15sir/bbs/board.php