코멘트부분에 wr_7과 ca_name만 추가 하고 싶은데요.. 정보
코멘트부분에 wr_7과 ca_name만 추가 하고 싶은데요..
본문
write.comment_update.skin.php
if ($is_admin=='super')
mysql_query(" update $write_table set ca_name = '$ca_name' where wr_id = '$wr_id' ");
mysql_query(" update $write_table set wr_7 = '$wr_7' where wr_id = '$wr_id' ");
//mysql_query(" update $write_table set wr_9 = '1' where wr_id = '$wr_id' ");
view_comment.skin.php
<input type=checkbox id="wr_secret" name="wr_secret" value="secret">비밀글
<? if ($is_admin) {?>
<input name="ca_name" type="radio" value="진행(进展)" <? if($write[ca_name]) ;?>/>
대기</label>
<input name="ca_name" type="radio" value="완료(完成)" <? if($write[ca_name]) ;?>/>
확정</label>
<input class='ed' style="width:70pt;" name=wr_7 id="wr_7" itemname="申请人电话号码" required maxlength='4' value="<?=$write[wr_7]?>">
적용은 되는데 카테고리는 적용이 되지 않고 wr_7만 적용이 됩니다.
어디가 잘몬 된걸까요?
if ($is_admin=='super')
mysql_query(" update $write_table set ca_name = '$ca_name' where wr_id = '$wr_id' ");
mysql_query(" update $write_table set wr_7 = '$wr_7' where wr_id = '$wr_id' ");
//mysql_query(" update $write_table set wr_9 = '1' where wr_id = '$wr_id' ");
view_comment.skin.php
<input type=checkbox id="wr_secret" name="wr_secret" value="secret">비밀글
<? if ($is_admin) {?>
<input name="ca_name" type="radio" value="진행(进展)" <? if($write[ca_name]) ;?>/>
대기</label>
<input name="ca_name" type="radio" value="완료(完成)" <? if($write[ca_name]) ;?>/>
확정</label>
<input class='ed' style="width:70pt;" name=wr_7 id="wr_7" itemname="申请人电话号码" required maxlength='4' value="<?=$write[wr_7]?>">
적용은 되는데 카테고리는 적용이 되지 않고 wr_7만 적용이 됩니다.
어디가 잘몬 된걸까요?
( 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 = '197937' 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