채택완료

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

2016-08-01 (월) 01:08:04 6,630

/adm/sql_write.sql

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

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

글쓰기폼은, <input  type="text" name="wr_25" value="<?=$write['wr_25']?>" id="wr_25"  class="frm_input" size="10" maxlength="100">  이렇게 처리가 되어있는데, 전혀 DB에 등록이 되지가 않습니다.

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

Copy
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;

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

Copy
$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);
 
|

답변 2개 / 댓글 3개

채택된 답변
+20 포인트
2016-08-01 (월) 01:19:23

sql_query($sql);

echo $sql;

exit;

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

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

답변에 대한 댓글 2개

2016-08-01 (월) 01:45:41
저문구는 어디다가넣어야되는건가요?
Write_update.php 에넣으면되나요
sql_query($sql);
이건 지금 위에 올리신 코드 제일 마지막 줄입니다.
그거 바로 밑에 빨간색 두 줄 넣어서 쿼리 찍어 보시면 됩니다.

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

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

이 부분을 참조해 보시죠.

답변에 대한 댓글 1개

2016-08-01 (월) 08:51:56
넵감사합니다

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