에러 코드좀 봐주셔요 채택완료
insert into ez_write_re03 set wr_num = '-15', wr_reply = '', wr_comment = 0, ca_name = '', wr_option = ',,', wr_subject = '2�몄떎', wr_content = 'kk', wr_link1 = '', wr_link2 = '', wr_link1_hit = 0, wr_link2_hit = 0, wr_trackback = '', wr_hit = 0, wr_good = 0, wr_nogood = 0, mb_id = 'admin', wr_password = '3007195b0cec296f', wr_name = '愿�由ъ옄', wr_email = 'id@yourdomain.com', wr_homepage = '', wr_datetime = '2016-03-24 15:15:58', wr_last = '2016-03-24 15:15:58', wr_ip = '118.38.75.14', wr_1 = '10', wr_2 = '4', wr_3 = '6', wr_4 = '50000', wr_5 = '70000', wr_6 = '160000', wr_7 = '160000', wr_8 = '10000', wr_9 = '70000', wr_10 = '160000', wr_20 = '111111', wr_21 = '222222, wr_22 = '888886'
1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '888886'' at line 36
error file : /V1/page/write_update_bbs.php
위에처럼 에러가 뜨는데 초보라 뭔지 모르겠네요....
답변 2개
wr_21 = '222222, wr_22 = '888886'
여기 보시면 작은따옴표 하나 빠졌어요.
wr_21 = '222222', wr_22 = '888886'
답변에 대한 댓글 2개
그누보드 기본 테이블이라면 wr_10까지만 있습니다.
해당 테이블에 칼럼을 추가해야 합니다.
여분 필드로 검색해 보세요.
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인
수정하고 나니...
insert into ez_write_re03 set wr_num = '-15', wr_reply = '', wr_comment = 0, ca_name = '', wr_option = ',,', wr_subject = '2�몄떎', wr_content = '�뤵뀖', wr_link1 = '', wr_link2 = '', wr_link1_hit = 0, wr_link2_hit = 0, wr_trackback = '', wr_hit = 0, wr_good = 0, wr_nogood = 0, mb_id = 'admin', wr_password = '3007195b0cec296f', wr_name = '愿�由ъ옄', wr_email = '*** 개인정보보호를 위한 이메일주소 노출방지 ***', wr_homepage = '', wr_datetime = '2016-03-24 16:19:48', wr_last = '2016-03-24 16:19:48', wr_ip = '118.38.75.14', wr_1 = '10', wr_2 = '4', wr_3 = '6', wr_4 = '50000', wr_5 = '70000', wr_6 = '160000', wr_7 = '160000', wr_8 = '10000', wr_9 = '70000', wr_10 = '160000', wr_12 = '', wr_13 = '', wr_14 = ''
1054 : Unknown column 'wr_12' in 'field list'
error file : /V1/page/write_update_bbs.php
필드값이 없다는거 같은데요...우째 해야 할까요?? 한번만 더 질문 드릴게요..