정보수정시 레벨따라 가는 페이지가 다를때... 정보
정보수정시 레벨따라 가는 페이지가 다를때...본문
<!-- 로그인 이전 -->
<li class="pt_5"><a href="<?=$g4['bbs_path']?>/login.php?url=<?=$urlencode?>"><img src="/images/common/btn_gnb_login.gif" alt="로그인"></a></li>
<li class="pt_5"><a href="<?=$g4['bbs_path']?>/register.php"><img src="/images/common/btn_gnb_join.gif" alt="회원가입"></a></li>
<? } else { ?>
<!-- 로그인 이후 -->
<li class="pt_5"><a href="<?=$g4['bbs_path']?>/logout.php"><img src="/images/common/top_m04.gif" border="0" alt="로그아웃"></a></li>
<li class="pt_5"><a href="<?=$g4['bbs_path']?>/member_confirm.php?url=register_form.php"><img src="/images/common/top_m05.gif" border="0" alt="정보수정"></a></li>
<? } ?>
<? if ($is_admin == "super" || $is_auth || $member[mb_level] > "7") { ?>
<li class="pt_5"><a href="<?=$g4['bbs_path']?>/member_confirm.php?url=register_form_pw.php">비밀번호변경</a></li>
<? } ?>
--------------------------------------------------------------------------------------
정보수정할때요 레벨7이상은 register_form_pw.php 이로 가고 레벨 그 이하는 register_form.php
가라는것을 어떻게 표현하죠?
( 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_id = '-1' and wr_id != '2008' ) union ( 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 = '268319' 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