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();
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();
댓글 전체
wr_11 필드가 없데요.
wr_11 부터 50까지 만들고나서 해 보세요.
wr_11 부터 50까지 만들고나서 해 보세요.
감사합니다.