write_update.php 오류 > 그누4 질문답변

그누4 질문답변

그누보드4 관련 질문은 QA 로 이전됩니다. QA 그누보드4 바로가기
기존 게시물은 열람만 가능합니다.

write_update.php 오류 정보

write_update.php 오류

본문

insert into g4_write_mad set wr_num = '-5', wr_reply = '', wr_comment = 0, ca_name = '', wr_option = ',,', wr_subject = '하이', 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 = '', wr_password = '032a15181bc6e1f3', wr_name = '나나나', wr_email = '', wr_homepage = '', wr_datetime = '2011-05-27 18:53:02', wr_last = '2011-05-27 18:53:02', wr_ip = '112.155.26.39', wr_1 = '볼보', wr_2 = 'S90', wr_3 = '3.0', wr_4 = '3', wr_5 = '300', wr_6 = '', wr_7 = '', wr_8 = '', wr_9 = '', wr_10 ='', wr_11 = '2008', wr_12 = '07', wr_13 = '1200000', wr_14 = '영업용', wr_15 = '자동', wr_16 = 'DOHC', wr_17 = '휘발유', wr_18 = '빨강', wr_19 = '무사고', wr_20 = '', wr_21 = '*** 개인정보보호를 위한 휴대폰번호 노출방지 ***', wr_22 = '', wr_23 = '', wr_24 = '', wr_25 = '', wr_26 = '', wr_27 = '', wr_28 = '', wr_29 = '', wr_30 = '', wr_31 = '', wr_32 = '', wr_33 = '', wr_34 = '', wr_35 = '', wr_36 = '', wr_37 = '', wr_38 = '', wr_39 = '', wr_40 = '', wr_41 = '', wr_42 = 'y', wr_43 = '', wr_44 = '', wr_45 = '', wr_46 = '', wr_47 = '', wr_48 = '', wr_49 = '', wr_50 = ''

1054 : Unknown column 'wr_11' in 'field list'

error file : /bbs/write_update.php
----------------------------->write_update.php 를 아래와 같이 수정하였는데도 위와같은 오류가 발생하네요.아래내용이 뭐가 잘못되었는지 답변좀 부탁드립니다.

$sql = " insert into $write_table
                set wr_num = '$wr_num',
                    wr_reply = '$wr_reply',
                    wr_comment = 0,
                    ca_name = '$ca_name',
                    wr_option = '$html,$secret,$mail',
                    wr_subject = '$wr_subject',
                    wr_content = '$wr_content',
                    wr_link1 = '$wr_link1',
                    wr_link2 = '$wr_link2',
                    wr_link1_hit = 0,
                    wr_link2_hit = 0,
                    wr_trackback = '$wr_trackback',
                    wr_hit = 0,
                    wr_good = 0,
                    wr_nogood = 0,
                    mb_id = '$member[mb_id]',
                    wr_password = '$wr_password',
                    wr_name = '$wr_name',
                    wr_email = '$wr_email',
                    wr_homepage = '$wr_homepage',
                    wr_datetime = '$g4[time_ymdhis]',
                    wr_last = '$g4[time_ymdhis]',
                    wr_ip = '$_SERVER[REMOTE_ADDR]',
                    wr_1 = '$wr_1',
                    wr_2 = '$wr_2',
                    wr_3 = '$wr_3',
                    wr_4 = '$wr_4',
                    wr_5 = '$wr_5',
                    wr_6 = '$wr_6',
                    wr_7 = '$wr_7',
                    wr_8 = '$wr_8',
                    wr_9 = '$wr_9',
                    wr_10 ='$wr_10',
                    wr_11  = '$wr_11',
      wr_12  = '$wr_12',
      wr_13  = '$wr_13',
      wr_14  = '$wr_14',
      wr_15  = '$wr_15',
      wr_16  = '$wr_16',
      wr_17  = '$wr_17',
      wr_18  = '$wr_18',
      wr_19  = '$wr_19',
      wr_20  = '$wr_20',
      wr_21  = '$wr_21',
      wr_22  = '$wr_22',
      wr_23  = '$wr_23',
      wr_24  = '$wr_24',
      wr_25  = '$wr_25',
      wr_26  = '$wr_26',
      wr_27  = '$wr_27',
      wr_28  = '$wr_28',
      wr_29  = '$wr_29',
      wr_30  = '$wr_30',
      wr_31  = '$wr_31',
      wr_32  = '$wr_32',
      wr_33  = '$wr_33',
      wr_34  = '$wr_34',
      wr_35  = '$wr_35',
      wr_36  = '$wr_36',
      wr_37  = '$wr_37',
      wr_38  = '$wr_38',
      wr_39  = '$wr_39',
      wr_40  = '$wr_40',
      wr_41  = '$wr_41',
      wr_42  = '$wr_42',
      wr_43  = '$wr_43',
      wr_44  = '$wr_44',
      wr_45  = '$wr_45',
      wr_46  = '$wr_46',
      wr_47  = '$wr_47',
      wr_48  = '$wr_48',
      wr_49  = '$wr_49',
      wr_50  = '$wr_50'


 ";
    sql_query($sql);

    $wr_id = mysql_insert_id();
  • 복사

댓글 전체

© SIRSOFT
현재 페이지 제일 처음으로