테스트 사이트 - 개발 중인 베타 버전입니다

그누보드 설치후 여분필드를 353개를 추가했는데요.글이 등록이 안되요 채택완료

별을따는소년 9년 전 조회 6,452

/adm/sql_write.sql

아래처럼 넣고 저장하니 phpmyadmin 에서 종류부분이 mediumtext 이렇게 자동 변환되는데요.

문제가 글을 등록하면은 글이 보이지가 않습니다. DB에도 등록이 안되어있구요.

 

글쓰기폼은,   이렇게 처리가 되어있는데, 전혀 DB에 등록이 되지가 않습니다.

 

어떻게 하면 될까요????? 방법좀 알려주세요! 고수님들 도와주세요 ㅠㅠ

 

</p><p>CREATE TABLE `__TABLE_NAME__` (
  `wr_id` int(11) NOT NULL AUTO_INCREMENT,
  `wr_num` int(11) NOT NULL DEFAULT '0',
  `wr_reply` varchar(10) NOT NULL,
  `wr_parent` int(11) NOT NULL DEFAULT '0',
  `wr_is_comment` tinyint(4) NOT NULL DEFAULT '0',
  `wr_comment` int(11) NOT NULL DEFAULT '0',
  `wr_comment_reply` varchar(5) NOT NULL,
  `ca_name` varchar(65535) NOT NULL,
  `wr_option` set('html1','html2','secret','mail') NOT NULL,
  `wr_subject` varchar(65535) NOT NULL,
  `wr_content` text NOT NULL,
  `wr_link1` text NOT NULL,
  `wr_link2` text NOT NULL,
  `wr_link1_hit` int(11) NOT NULL DEFAULT '0',
  `wr_link2_hit` int(11) NOT NULL DEFAULT '0',
  `wr_hit` int(11) NOT NULL DEFAULT '0',
  `wr_good` int(11) NOT NULL DEFAULT '0',
  `wr_nogood` int(11) NOT NULL DEFAULT '0',
  `mb_id` varchar(20) NOT NULL,
  `wr_password` varchar(65535) NOT NULL,
  `wr_name` varchar(65535) NOT NULL,
  `wr_email` varchar(65535) NOT NULL,
  `wr_homepage` varchar(65535) NOT NULL,
  `wr_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `wr_file` tinyint(4) NOT NULL DEFAULT '0',
  `wr_last` varchar(19) NOT NULL,
  `wr_ip` varchar(65535) NOT NULL,
  `wr_facebook_user` varchar(65535) NOT NULL,
  `wr_twitter_user` varchar(65535) NOT NULL,
  `wr_1` varchar(65535) NOT NULL,
  `wr_2` varchar(65535) NOT NULL,
  `wr_3` varchar(65535) NOT NULL,
  `wr_4` varchar(65535) NOT NULL,
  `wr_5` varchar(65535) NOT NULL,
  `wr_6` varchar(65535) NOT NULL,
  `wr_7` varchar(65535) NOT NULL,
  `wr_8` varchar(65535) NOT NULL,
  `wr_9` varchar(65535) NOT NULL,
`wr_10` varchar(65535) NOT NULL,
`wr_11` varchar(65535) NOT NULL,
`wr_12` varchar(65535) NOT NULL,
`wr_13` varchar(65535) NOT NULL,
`wr_14` varchar(65535) NOT NULL,
`wr_15` varchar(65535) NOT NULL,
`wr_16` varchar(65535) NOT NULL,
`wr_17` varchar(65535) NOT NULL,
`wr_18` varchar(65535) NOT NULL,
`wr_19` varchar(65535) NOT NULL,
`wr_20` varchar(65535) NOT NULL,
`wr_21` varchar(65535) NOT NULL,
`wr_22` varchar(65535) NOT NULL,
`wr_23` varchar(65535) NOT NULL,
`wr_24` varchar(65535) NOT NULL,
`wr_25` varchar(65535) NOT NULL,
`wr_26` varchar(65535) NOT NULL,
`wr_27` varchar(65535) NOT NULL,
`wr_28` varchar(65535) NOT NULL,
`wr_29` varchar(65535) NOT NULL,
`wr_30` varchar(65535) NOT NULL,
`wr_31` varchar(65535) NOT NULL,
`wr_32` varchar(65535) NOT NULL,
`wr_33` varchar(65535) NOT NULL,
`wr_34` varchar(65535) NOT NULL,
`wr_35` varchar(65535) NOT NULL,
`wr_36` varchar(65535) NOT NULL,
`wr_37` varchar(65535) NOT NULL,
`wr_38` varchar(65535) NOT NULL,
`wr_39` varchar(65535) NOT NULL,
`wr_40` varchar(65535) NOT NULL,
`wr_41` varchar(65535) NOT NULL,
`wr_42` varchar(65535) NOT NULL,
`wr_43` varchar(65535) NOT NULL,
`wr_44` varchar(65535) NOT NULL,
`wr_45` varchar(65535) NOT NULL,
`wr_46` varchar(65535) NOT NULL,
`wr_47` varchar(65535) NOT NULL,
`wr_48` varchar(65535) NOT NULL,
`wr_49` varchar(65535) NOT NULL,
`wr_50` varchar(65535) NOT NULL,
`wr_51` varchar(65535) NOT NULL,
`wr_52` varchar(65535) NOT NULL,
`wr_53` varchar(65535) NOT NULL,
`wr_54` varchar(65535) NOT NULL,
`wr_55` varchar(65535) NOT NULL,
`wr_56` varchar(65535) NOT NULL,
`wr_57` varchar(65535) NOT NULL,
`wr_58` varchar(65535) NOT NULL,
`wr_59` varchar(65535) NOT NULL,
`wr_60` varchar(65535) NOT NULL,
`wr_61` varchar(65535) NOT NULL,
`wr_62` varchar(65535) NOT NULL,
`wr_63` varchar(65535) NOT NULL,
`wr_64` varchar(65535) NOT NULL,
`wr_65` varchar(65535) NOT NULL,
`wr_66` varchar(65535) NOT NULL,
`wr_67` varchar(65535) NOT NULL,
`wr_68` varchar(65535) NOT NULL,
`wr_69` varchar(65535) NOT NULL,
`wr_70` varchar(65535) NOT NULL,
`wr_71` varchar(65535) NOT NULL,
`wr_72` varchar(65535) NOT NULL,
`wr_73` varchar(65535) NOT NULL,
`wr_74` varchar(65535) NOT NULL,
`wr_75` varchar(65535) NOT NULL,
`wr_76` varchar(65535) NOT NULL,
`wr_77` varchar(65535) NOT NULL,
`wr_78` varchar(65535) NOT NULL,
`wr_79` varchar(65535) NOT NULL,
`wr_80` varchar(65535) NOT NULL,
`wr_81` varchar(65535) NOT NULL,
`wr_82` varchar(65535) NOT NULL,
`wr_83` varchar(65535) NOT NULL,
`wr_84` varchar(65535) NOT NULL,
`wr_85` varchar(65535) NOT NULL,
`wr_86` varchar(65535) NOT NULL,
`wr_87` varchar(65535) NOT NULL,
`wr_88` varchar(65535) NOT NULL,
`wr_89` varchar(65535) NOT NULL,
`wr_90` varchar(65535) NOT NULL,
`wr_91` varchar(65535) NOT NULL,
`wr_92` varchar(65535) NOT NULL,
`wr_93` varchar(65535) NOT NULL,
`wr_94` varchar(65535) NOT NULL,
`wr_95` varchar(65535) NOT NULL,
`wr_96` varchar(65535) NOT NULL,
`wr_97` varchar(65535) NOT NULL,
`wr_98` varchar(65535) NOT NULL,
`wr_99` varchar(65535) NOT NULL,
`wr_100` varchar(65535) NOT NULL,
`wr_101` varchar(65535) NOT NULL,
`wr_102` varchar(65535) NOT NULL,
`wr_103` varchar(65535) NOT NULL,
`wr_104` varchar(65535) NOT NULL,
`wr_105` varchar(65535) NOT NULL,
`wr_106` varchar(65535) NOT NULL,
`wr_107` varchar(65535) NOT NULL,
`wr_108` varchar(65535) NOT NULL,
`wr_109` varchar(65535) NOT NULL,
`wr_110` varchar(65535) NOT NULL,
`wr_111` varchar(65535) NOT NULL,
`wr_112` varchar(65535) NOT NULL,
`wr_113` varchar(65535) NOT NULL,
`wr_114` varchar(65535) NOT NULL,
`wr_115` varchar(65535) NOT NULL,
`wr_116` varchar(65535) NOT NULL,
`wr_117` varchar(65535) NOT NULL,
`wr_118` varchar(65535) NOT NULL,
`wr_119` varchar(65535) NOT NULL,
`wr_120` varchar(65535) NOT NULL,
`wr_121` varchar(65535) NOT NULL,
`wr_122` varchar(65535) NOT NULL,
`wr_123` varchar(65535) NOT NULL,
`wr_124` varchar(65535) NOT NULL,
`wr_125` varchar(65535) NOT NULL,
`wr_126` varchar(65535) NOT NULL,
`wr_127` varchar(65535) NOT NULL,
`wr_128` varchar(65535) NOT NULL,
`wr_129` varchar(65535) NOT NULL,
`wr_130` varchar(65535) NOT NULL,
`wr_131` varchar(65535) NOT NULL,
`wr_132` varchar(65535) NOT NULL,
`wr_133` varchar(65535) NOT NULL,
`wr_134` varchar(65535) NOT NULL,
`wr_135` varchar(65535) NOT NULL,
`wr_136` varchar(65535) NOT NULL,
`wr_137` varchar(65535) NOT NULL,
`wr_138` varchar(65535) NOT NULL,
`wr_139` varchar(65535) NOT NULL,
`wr_140` varchar(65535) NOT NULL,
`wr_141` varchar(65535) NOT NULL,
`wr_142` varchar(65535) NOT NULL,
`wr_143` varchar(65535) NOT NULL,
`wr_144` varchar(65535) NOT NULL,
`wr_145` varchar(65535) NOT NULL,
`wr_146` varchar(65535) NOT NULL,
`wr_147` varchar(65535) NOT NULL,
`wr_148` varchar(65535) NOT NULL,
`wr_149` varchar(65535) NOT NULL,
`wr_150` varchar(65535) NOT NULL,
`wr_151` varchar(65535) NOT NULL,
`wr_152` varchar(65535) NOT NULL,
`wr_153` varchar(65535) NOT NULL,
`wr_154` varchar(65535) NOT NULL,
`wr_155` varchar(65535) NOT NULL,
`wr_156` varchar(65535) NOT NULL,
`wr_157` varchar(65535) NOT NULL,
`wr_158` varchar(65535) NOT NULL,
`wr_159` varchar(65535) NOT NULL,
`wr_160` varchar(65535) NOT NULL,
`wr_161` varchar(65535) NOT NULL,
`wr_162` varchar(65535) NOT NULL,
`wr_163` varchar(65535) NOT NULL,
`wr_164` varchar(65535) NOT NULL,
`wr_165` varchar(65535) NOT NULL,
`wr_166` varchar(65535) NOT NULL,
`wr_167` varchar(65535) NOT NULL,
`wr_168` varchar(65535) NOT NULL,
`wr_169` varchar(65535) NOT NULL,
`wr_170` varchar(65535) NOT NULL,
`wr_171` varchar(65535) NOT NULL,
`wr_172` varchar(65535) NOT NULL,
`wr_173` varchar(65535) NOT NULL,
`wr_174` varchar(65535) NOT NULL,
`wr_175` varchar(65535) NOT NULL,
`wr_176` varchar(65535) NOT NULL,
`wr_177` varchar(65535) NOT NULL,
`wr_178` varchar(65535) NOT NULL,
`wr_179` varchar(65535) NOT NULL,
`wr_180` varchar(65535) NOT NULL,
`wr_181` varchar(65535) NOT NULL,
`wr_182` varchar(65535) NOT NULL,
`wr_183` varchar(65535) NOT NULL,
`wr_184` varchar(65535) NOT NULL,
`wr_185` varchar(65535) NOT NULL,
`wr_186` varchar(65535) NOT NULL,
`wr_187` varchar(65535) NOT NULL,
`wr_188` varchar(65535) NOT NULL,
`wr_189` varchar(65535) NOT NULL,
`wr_190` varchar(65535) NOT NULL,
`wr_191` varchar(65535) NOT NULL,
`wr_192` varchar(65535) NOT NULL,
`wr_193` varchar(65535) NOT NULL,
`wr_194` varchar(65535) NOT NULL,
`wr_195` varchar(65535) NOT NULL,
`wr_196` varchar(65535) NOT NULL,
`wr_197` varchar(65535) NOT NULL,
`wr_198` varchar(65535) NOT NULL,
`wr_199` varchar(65535) NOT NULL,
`wr_200` varchar(65535) NOT NULL,
`wr_201` varchar(65535) NOT NULL,
`wr_202` varchar(65535) NOT NULL,
`wr_203` varchar(65535) NOT NULL,
`wr_204` varchar(65535) NOT NULL,
`wr_205` varchar(65535) NOT NULL,
`wr_206` varchar(65535) NOT NULL,
`wr_207` varchar(65535) NOT NULL,
`wr_208` varchar(65535) NOT NULL,
`wr_209` varchar(65535) NOT NULL,
`wr_210` varchar(65535) NOT NULL,
`wr_211` varchar(65535) NOT NULL,
`wr_212` varchar(65535) NOT NULL,
`wr_213` varchar(65535) NOT NULL,
`wr_214` varchar(65535) NOT NULL,
`wr_215` varchar(65535) NOT NULL,
`wr_216` varchar(65535) NOT NULL,
`wr_217` varchar(65535) NOT NULL,
`wr_218` varchar(65535) NOT NULL,
`wr_219` varchar(65535) NOT NULL,
`wr_220` varchar(65535) NOT NULL,
`wr_221` varchar(65535) NOT NULL,
`wr_222` varchar(65535) NOT NULL,
`wr_223` varchar(65535) NOT NULL,
`wr_224` varchar(65535) NOT NULL,
`wr_225` varchar(65535) NOT NULL,
`wr_226` varchar(65535) NOT NULL,
`wr_227` varchar(65535) NOT NULL,
`wr_228` varchar(65535) NOT NULL,
`wr_229` varchar(65535) NOT NULL,
`wr_230` varchar(65535) NOT NULL,
`wr_231` varchar(65535) NOT NULL,
`wr_232` varchar(65535) NOT NULL,
`wr_233` varchar(65535) NOT NULL,
`wr_234` varchar(65535) NOT NULL,
`wr_235` varchar(65535) NOT NULL,
`wr_236` varchar(65535) NOT NULL,
`wr_237` varchar(65535) NOT NULL,
`wr_238` varchar(65535) NOT NULL,
`wr_239` varchar(65535) NOT NULL,
`wr_240` varchar(65535) NOT NULL,
`wr_241` varchar(65535) NOT NULL,
`wr_242` varchar(65535) NOT NULL,
`wr_243` varchar(65535) NOT NULL,
`wr_244` varchar(65535) NOT NULL,
`wr_245` varchar(65535) NOT NULL,
`wr_246` varchar(65535) NOT NULL,
`wr_247` varchar(65535) NOT NULL,
`wr_248` varchar(65535) NOT NULL,
`wr_249` varchar(65535) NOT NULL,
`wr_250` varchar(65535) NOT NULL,
`wr_251` varchar(65535) NOT NULL,
`wr_252` varchar(65535) NOT NULL,
`wr_253` varchar(65535) NOT NULL,
`wr_254` varchar(65535) NOT NULL,
`wr_255` varchar(65535) NOT NULL,
`wr_256` varchar(65535) NOT NULL,
`wr_257` varchar(65535) NOT NULL,
`wr_258` varchar(65535) NOT NULL,
`wr_259` varchar(65535) NOT NULL,
`wr_260` varchar(65535) NOT NULL,
`wr_261` varchar(65535) NOT NULL,
`wr_262` varchar(65535) NOT NULL,
`wr_263` varchar(65535) NOT NULL,
`wr_264` varchar(65535) NOT NULL,
`wr_265` varchar(65535) NOT NULL,
`wr_266` varchar(65535) NOT NULL,
`wr_267` varchar(65535) NOT NULL,
`wr_268` varchar(65535) NOT NULL,
`wr_269` varchar(65535) NOT NULL,
`wr_270` varchar(65535) NOT NULL,
`wr_271` varchar(65535) NOT NULL,
`wr_272` varchar(65535) NOT NULL,
`wr_273` varchar(65535) NOT NULL,
`wr_274` varchar(65535) NOT NULL,
`wr_275` varchar(65535) NOT NULL,
`wr_276` varchar(65535) NOT NULL,
`wr_277` varchar(65535) NOT NULL,
`wr_278` varchar(65535) NOT NULL,
`wr_279` varchar(65535) NOT NULL,
`wr_280` varchar(65535) NOT NULL,
`wr_281` varchar(65535) NOT NULL,
`wr_282` varchar(65535) NOT NULL,
`wr_283` varchar(65535) NOT NULL,
`wr_284` varchar(65535) NOT NULL,
`wr_285` varchar(65535) NOT NULL,
`wr_286` varchar(65535) NOT NULL,
`wr_287` varchar(65535) NOT NULL,
`wr_288` varchar(65535) NOT NULL,
`wr_289` varchar(65535) NOT NULL,
`wr_290` varchar(65535) NOT NULL,
`wr_291` varchar(65535) NOT NULL,
`wr_292` varchar(65535) NOT NULL,
`wr_293` varchar(65535) NOT NULL,
`wr_294` varchar(65535) NOT NULL,
`wr_295` varchar(65535) NOT NULL,
`wr_296` varchar(65535) NOT NULL,
`wr_297` varchar(65535) NOT NULL,
`wr_298` varchar(65535) NOT NULL,
`wr_299` varchar(65535) NOT NULL,
`wr_300` varchar(65535) NOT NULL,
`wr_301` varchar(65535) NOT NULL,
`wr_302` varchar(65535) NOT NULL,
`wr_303` varchar(65535) NOT NULL,
`wr_304` varchar(65535) NOT NULL,
`wr_305` varchar(65535) NOT NULL,
`wr_306` varchar(65535) NOT NULL,
`wr_307` varchar(65535) NOT NULL,
`wr_308` varchar(65535) NOT NULL,
`wr_309` varchar(65535) NOT NULL,
`wr_310` varchar(65535) NOT NULL,
`wr_311` varchar(65535) NOT NULL,
`wr_312` varchar(65535) NOT NULL,
`wr_313` varchar(65535) NOT NULL,
`wr_314` varchar(65535) NOT NULL,
`wr_315` varchar(65535) NOT NULL,
`wr_316` varchar(65535) NOT NULL,
`wr_317` varchar(65535) NOT NULL,
`wr_318` varchar(65535) NOT NULL,
`wr_319` varchar(65535) NOT NULL,
`wr_320` varchar(65535) NOT NULL,
`wr_321` varchar(65535) NOT NULL,
`wr_322` varchar(65535) NOT NULL,
`wr_323` varchar(65535) NOT NULL,
`wr_324` varchar(65535) NOT NULL,
`wr_325` varchar(65535) NOT NULL,
`wr_326` varchar(65535) NOT NULL,
`wr_327` varchar(65535) NOT NULL,
`wr_328` varchar(65535) NOT NULL,
`wr_329` varchar(65535) NOT NULL,
`wr_330` varchar(65535) NOT NULL,
`wr_331` varchar(65535) NOT NULL,
`wr_332` varchar(65535) NOT NULL,
`wr_333` varchar(65535) NOT NULL,
`wr_334` varchar(65535) NOT NULL,
`wr_335` varchar(65535) NOT NULL,
`wr_336` varchar(65535) NOT NULL,
`wr_337` varchar(65535) NOT NULL,
`wr_338` varchar(65535) NOT NULL,
`wr_339` varchar(65535) NOT NULL,
`wr_340` varchar(65535) NOT NULL,
`wr_341` varchar(65535) NOT NULL,
`wr_342` varchar(65535) NOT NULL,
`wr_343` varchar(65535) NOT NULL,
`wr_344` varchar(65535) NOT NULL,
`wr_345` varchar(65535) NOT NULL,
`wr_346` varchar(65535) NOT NULL,
`wr_347` varchar(65535) NOT NULL,
`wr_348` varchar(65535) NOT NULL,
`wr_349` varchar(65535) NOT NULL,
`wr_350` varchar(65535) NOT NULL,
`wr_351` varchar(65535) NOT NULL,
`wr_352` varchar(65535) NOT NULL,
`wr_353` varchar(65535) NOT NULL,
  PRIMARY KEY (`wr_id`),
  KEY `wr_num_reply_parent` (`wr_num`,`wr_reply`,`wr_parent`),
  KEY `wr_is_comment` (`wr_is_comment`,`wr_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;</p><p>

 

/bbs/write_update.php 안에도 여분필드한거는 추가를 해놓았습니다.

 

</p><p>    $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_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 = '".G5_TIME_YMDHIS."',
                     wr_last = '".G5_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',
     wr_51 = '$wr_51',
     wr_52 = '$wr_52',
     wr_53 = '$wr_53',
     wr_54 = '$wr_54',
     wr_55 = '$wr_55',
     wr_56 = '$wr_56',
     wr_57 = '$wr_57',
     wr_58 = '$wr_58',
     wr_59 = '$wr_59',
     wr_60 = '$wr_60',
     wr_61 = '$wr_61',
     wr_62 = '$wr_62',
     wr_63 = '$wr_63',
     wr_64 = '$wr_64',
     wr_65 = '$wr_65',
     wr_66 = '$wr_66',
     wr_67 = '$wr_67',
     wr_68 = '$wr_68',
     wr_69 = '$wr_69',
     wr_70 = '$wr_70',
     wr_71 = '$wr_71',
     wr_72 = '$wr_72',
     wr_73 = '$wr_73',
     wr_74 = '$wr_74',
     wr_75 = '$wr_75',
     wr_76 = '$wr_76',
     wr_77 = '$wr_77',
     wr_78 = '$wr_78',
     wr_79 = '$wr_79',
     wr_80 = '$wr_80',
     wr_81 = '$wr_81',
     wr_82 = '$wr_82',
     wr_83 = '$wr_83',
     wr_84 = '$wr_84',
     wr_85 = '$wr_85',
     wr_86 = '$wr_86',
     wr_87 = '$wr_87',
     wr_88 = '$wr_88',
     wr_89 = '$wr_89',
     wr_90 = '$wr_90',
     wr_91 = '$wr_91',
     wr_92 = '$wr_92',
     wr_93 = '$wr_93',
     wr_94 = '$wr_94',
     wr_95 = '$wr_95',
     wr_96 = '$wr_96',
     wr_97 = '$wr_97',
     wr_98 = '$wr_98',
     wr_99 = '$wr_99',
     wr_100 = '$wr_100',
     wr_101 = '$wr_101',
     wr_102 = '$wr_102',
     wr_103 = '$wr_103',
     wr_104 = '$wr_104',
     wr_105 = '$wr_105',
     wr_106 = '$wr_106',
     wr_107 = '$wr_107',
     wr_108 = '$wr_108',
     wr_109 = '$wr_109',
     wr_110 = '$wr_110',
     wr_111 = '$wr_111',
     wr_112 = '$wr_112',
     wr_113 = '$wr_113',
     wr_114 = '$wr_114',
     wr_115 = '$wr_115',
     wr_116 = '$wr_116',
     wr_117 = '$wr_117',
     wr_118 = '$wr_118',
     wr_119 = '$wr_119',
     wr_120 = '$wr_120',
     wr_121 = '$wr_121',
     wr_122 = '$wr_122',
     wr_123 = '$wr_123',
     wr_124 = '$wr_124',
     wr_125 = '$wr_125',
     wr_126 = '$wr_126',
     wr_127 = '$wr_127',
     wr_128 = '$wr_128',
     wr_129 = '$wr_129',
     wr_130 = '$wr_130',
     wr_131 = '$wr_131',
     wr_132 = '$wr_132',
     wr_133 = '$wr_133',
     wr_134 = '$wr_134',
     wr_135 = '$wr_135',
     wr_136 = '$wr_136',
     wr_137 = '$wr_137',
     wr_138 = '$wr_138',
     wr_139 = '$wr_139',
     wr_140 = '$wr_140',
     wr_141 = '$wr_141',
     wr_142 = '$wr_142',
     wr_143 = '$wr_143',
     wr_144 = '$wr_144',
     wr_145 = '$wr_145',
     wr_146 = '$wr_146',
     wr_147 = '$wr_147',
     wr_148 = '$wr_148',
     wr_149 = '$wr_149',
     wr_150 = '$wr_150',
     wr_151 = '$wr_151',
     wr_152 = '$wr_152',
     wr_153 = '$wr_153',
     wr_154 = '$wr_154',
     wr_155 = '$wr_155',
     wr_156 = '$wr_156',
     wr_157 = '$wr_157',
     wr_158 = '$wr_158',
     wr_159 = '$wr_159',
     wr_160 = '$wr_160',
     wr_161 = '$wr_161',
     wr_162 = '$wr_162',
     wr_163 = '$wr_163',
     wr_164 = '$wr_164',
     wr_165 = '$wr_165',
     wr_166 = '$wr_166',
     wr_167 = '$wr_167',
     wr_168 = '$wr_168',
     wr_169 = '$wr_169',
     wr_170 = '$wr_170',
     wr_171 = '$wr_171',
     wr_172 = '$wr_172',
     wr_173 = '$wr_173',
     wr_174 = '$wr_174',
     wr_175 = '$wr_175',
     wr_176 = '$wr_176',
     wr_177 = '$wr_177',
     wr_178 = '$wr_178',
     wr_179 = '$wr_179',
     wr_180 = '$wr_180',
     wr_181 = '$wr_181',
     wr_182 = '$wr_182',
     wr_183 = '$wr_183',
     wr_184 = '$wr_184',
     wr_185 = '$wr_185',
     wr_186 = '$wr_186',
     wr_187 = '$wr_187',
     wr_188 = '$wr_188',
     wr_189 = '$wr_189',
     wr_190 = '$wr_190',
     wr_191 = '$wr_191',
     wr_192 = '$wr_192',
     wr_193 = '$wr_193',
     wr_194 = '$wr_194',
     wr_195 = '$wr_195',
     wr_196 = '$wr_196',
     wr_197 = '$wr_197',
     wr_198 = '$wr_198',
     wr_199 = '$wr_199',
     wr_200 = '$wr_200',
     wr_201 = '$wr_201',
     wr_202 = '$wr_202',
     wr_203 = '$wr_203',
     wr_204 = '$wr_204',
     wr_205 = '$wr_205',
     wr_206 = '$wr_206',
     wr_207 = '$wr_207',
     wr_208 = '$wr_208',
     wr_209 = '$wr_209',
     wr_210 = '$wr_210',
     wr_211 = '$wr_211',
     wr_212 = '$wr_212',
     wr_213 = '$wr_213',
     wr_214 = '$wr_214',
     wr_215 = '$wr_215',
     wr_216 = '$wr_216',
     wr_217 = '$wr_217',
     wr_218 = '$wr_218',
     wr_219 = '$wr_219',
     wr_220 = '$wr_220',
     wr_221 = '$wr_221',
     wr_222 = '$wr_222',
     wr_223 = '$wr_223',
     wr_224 = '$wr_224',
     wr_225 = '$wr_225',
     wr_226 = '$wr_226',
     wr_227 = '$wr_227',
     wr_228 = '$wr_228',
     wr_229 = '$wr_229',
     wr_230 = '$wr_230',
     wr_231 = '$wr_231',
     wr_232 = '$wr_232',
     wr_233 = '$wr_233',
     wr_234 = '$wr_234',
     wr_235 = '$wr_235',
     wr_236 = '$wr_236',
     wr_237 = '$wr_237',
     wr_238 = '$wr_238',
     wr_239 = '$wr_239',
     wr_240 = '$wr_240',
     wr_241 = '$wr_241',
     wr_242 = '$wr_242',
     wr_243 = '$wr_243',
     wr_244 = '$wr_244',
     wr_245 = '$wr_245',
     wr_246 = '$wr_246',
     wr_247 = '$wr_247',
     wr_248 = '$wr_248',
     wr_249 = '$wr_249',
     wr_250 = '$wr_250',
     wr_251 = '$wr_251',
     wr_252 = '$wr_252',
     wr_253 = '$wr_253',
     wr_254 = '$wr_254',
     wr_255 = '$wr_255',
     wr_256 = '$wr_256',
     wr_257 = '$wr_257',
     wr_258 = '$wr_258',
     wr_259 = '$wr_259',
     wr_260 = '$wr_260',
     wr_261 = '$wr_261',
     wr_262 = '$wr_262',
     wr_263 = '$wr_263',
     wr_264 = '$wr_264',
     wr_265 = '$wr_265',
     wr_266 = '$wr_266',
     wr_267 = '$wr_267',
     wr_268 = '$wr_268',
     wr_269 = '$wr_269',
     wr_270 = '$wr_270',
     wr_271 = '$wr_271',
     wr_272 = '$wr_272',
     wr_273 = '$wr_273',
     wr_274 = '$wr_274',
     wr_275 = '$wr_275',
     wr_276 = '$wr_276',
     wr_277 = '$wr_277',
     wr_278 = '$wr_278',
     wr_279 = '$wr_279',
     wr_280 = '$wr_280',
     wr_281 = '$wr_281',
     wr_282 = '$wr_282',
     wr_283 = '$wr_283',
     wr_284 = '$wr_284',
     wr_285 = '$wr_285',
     wr_286 = '$wr_286',
     wr_287 = '$wr_287',
     wr_288 = '$wr_288',
     wr_289 = '$wr_289',
     wr_290 = '$wr_290',
     wr_291 = '$wr_291',
     wr_292 = '$wr_292',
     wr_293 = '$wr_293',
     wr_294 = '$wr_294',
     wr_295 = '$wr_295',
     wr_296 = '$wr_296',
     wr_297 = '$wr_297',
     wr_298 = '$wr_298',
     wr_299 = '$wr_299',
     wr_300 = '$wr_300',
     wr_301 = '$wr_301',
     wr_302 = '$wr_302',
     wr_303 = '$wr_303',
     wr_304 = '$wr_304',
     wr_305 = '$wr_305',
     wr_306 = '$wr_306',
     wr_307 = '$wr_307',
     wr_308 = '$wr_308',
     wr_309 = '$wr_309',
     wr_310 = '$wr_310',
     wr_311 = '$wr_311',
     wr_312 = '$wr_312',
     wr_313 = '$wr_313',
     wr_314 = '$wr_314',
     wr_315 = '$wr_315',
     wr_316 = '$wr_316',
     wr_317 = '$wr_317',
     wr_318 = '$wr_318',
     wr_319 = '$wr_319',
     wr_320 = '$wr_320',
     wr_321 = '$wr_321',
     wr_322 = '$wr_322',
     wr_323 = '$wr_323',
     wr_324 = '$wr_324',
     wr_325 = '$wr_325',
     wr_326 = '$wr_326',
     wr_327 = '$wr_327',
     wr_328 = '$wr_328',
     wr_329 = '$wr_329',
     wr_330 = '$wr_330',
     wr_331 = '$wr_331',
     wr_332 = '$wr_332',
     wr_333 = '$wr_333',
     wr_334 = '$wr_334',
     wr_335 = '$wr_335',
     wr_336 = '$wr_336',
     wr_337 = '$wr_337',
     wr_338 = '$wr_338',
     wr_339 = '$wr_339',
     wr_340 = '$wr_340',
     wr_341 = '$wr_341',
     wr_342 = '$wr_342',
     wr_343 = '$wr_343',
     wr_344 = '$wr_344',
     wr_345 = '$wr_345',
     wr_346 = '$wr_346',
     wr_347 = '$wr_347',
     wr_348 = '$wr_348',
     wr_349 = '$wr_349',
     wr_350 = '$wr_350',
     wr_351 = '$wr_351',
     wr_352 = '$wr_352',
     wr_353 = '$wr_353'";
    sql_query($sql);</p><p>
 

댓글을 작성하려면 로그인이 필요합니다.

답변 2개

채택된 답변
+20 포인트

sql_query($sql);

echo $sql;

exit;

이렇게 해서 쿼리가 정상적으로 찍히는지 확인해 보세요.

쿼리가 나오면 그거 그대로 복사해서 phpmyadmin 같은 데에 넣어서 실행했을 때 에러 메시지 나오는지도 확인해 보셔야 할 것 같습니다. 

로그인 후 평가할 수 있습니다

답변에 대한 댓글 2개

별을따는소년
9년 전
저문구는 어디다가넣어야되는건가요?
Write_update.php 에넣으면되나요
왕계란
9년 전
sql_query($sql);
이건 지금 위에 올리신 코드 제일 마지막 줄입니다.
그거 바로 밑에 빨간색 두 줄 넣어서 쿼리 찍어 보시면 됩니다.

댓글을 작성하려면 로그인이 필요합니다.

9년 전

mysql문서를 보면 varchar타입으로 만들 수 있는 컬럼의 갯수가 78개인가 였던 것으로

읽었던듯 싶어 text로 바꾸고는 됐던거 같습니다.

이 부분을 참조해 보시죠.

로그인 후 평가할 수 있습니다

답변에 대한 댓글 1개

별을따는소년
9년 전
넵감사합니다

댓글을 작성하려면 로그인이 필요합니다.

답변을 작성하려면 로그인이 필요합니다.

로그인