여분필드 추가 사용법 질문드려요.. 정보
여분필드 추가 사용법 질문드려요..본문
list.skin write.skin 에 wr_14까지 들어가게 폼은 만들어 두었구요.
g4_write_test db에 wr_14까지 필드 추가해 놓은 상태입니다.
그렇게 해서 글을 써보니 wr_11부터는 저장이 안되더라구요
그래서 검색하다 보니
write_update.skin 에
<?
$sql = " update $write_table set
wr_11 = '$wr_11',
wr_12 = '$wr_12',
wr_13 = '$wr_13',
wr_14 = '$wr_14'
where wr_id = '$wr[wr_id]' ";
sql_query($sql);
?>
넣으라고 하더라구요..
저렇게 해도 wr_11부터는 저장이 안되요..
도와주세요 ㅠ
( 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 = '228518' 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 = '228495' 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