채택완료
그누보드 설치후 여분필드를 353개를 추가했는데요.글이 등록이 안되요
/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
2016-08-01 (월) 09:42:41
sql_query($sql);
이건 지금 위에 올리신 코드 제일 마지막 줄입니다.
그거 바로 밑에 빨간색 두 줄 넣어서 쿼리 찍어 보시면 됩니다.
이건 지금 위에 올리신 코드 제일 마지막 줄입니다.
그거 바로 밑에 빨간색 두 줄 넣어서 쿼리 찍어 보시면 됩니다.
2016-08-01 (월) 08:18:47
mysql문서를 보면 varchar타입으로 만들 수 있는 컬럼의 갯수가 78개인가 였던 것으로
읽었던듯 싶어 text로 바꾸고는 됐던거 같습니다.
이 부분을 참조해 보시죠.
답변에 대한 댓글 1개
답변을 작성하려면 로그인이 필요합니다.
Write_update.php 에넣으면되나요