그누보드 설치후 여분필드를 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에 등록이 되지가 않습니다.
어떻게 하면 될까요????? 방법좀 알려주세요! 고수님들 도와주세요 ㅠㅠ
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 안에도 여분필드한거는 추가를 해놓았습니다.
$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
sql_query($sql);
echo $sql;
exit;
이렇게 해서 쿼리가 정상적으로 찍히는지 확인해 보세요.
쿼리가 나오면 그거 그대로 복사해서 phpmyadmin 같은 데에 넣어서 실행했을 때 에러 메시지 나오는지도 확인해 보셔야 할 것 같습니다.
저문구는 어디다가넣어야되는건가요?
Write_update.php 에넣으면되나요
sql_query($sql);
이건 지금 위에 올리신 코드 제일 마지막 줄입니다.
그거 바로 밑에 빨간색 두 줄 넣어서 쿼리 찍어 보시면 됩니다.
mysql문서를 보면 varchar타입으로 만들 수 있는 컬럼의 갯수가 78개인가 였던 것으로
읽었던듯 싶어 text로 바꾸고는 됐던거 같습니다.
이 부분을 참조해 보시죠.
넵감사합니다
답변을 작성하시기 전에 로그인 해주세요.
