Есть база: Код (PHP): CREATE TABLE IF NOT EXISTS `users` ( `id` int(4) NOT NULL, `profesia` int(50) NOT NULL, `obl` int(2) NOT NULL, `city` int(2) NOT NULL, `name` text COLLATE utf8_bin NOT NULL, `mail` varchar(50) COLLATE utf8_bin NOT NULL, `phone` varchar(12) COLLATE utf8_bin NOT NULL, `social1` varchar(50) COLLATE utf8_bin NOT NULL, `social2` varchar(50) COLLATE utf8_bin NOT NULL, `oplata` varchar(25) COLLATE utf8_bin NOT NULL, `foto` varchar(25) COLLATE utf8_bin NOT NULL, `text` text COLLATE utf8_bin NOT NULL, `cityname` text COLLATE utf8_bin NOT NULL, `ad` int(2) NOT NULL, `position` int(3) NOT NULL, `portfolio1` varchar(25) COLLATE utf8_bin NOT NULL, `portfolio2` varchar(25) COLLATE utf8_bin NOT NULL, `portfolio3` varchar(25) COLLATE utf8_bin NOT NULL, `portfolio4` varchar(25) COLLATE utf8_bin NOT NULL, `portfolio5` varchar(25) COLLATE utf8_bin NOT NULL, `portfolio6` varchar(25) COLLATE utf8_bin NOT NULL, `portfolio7` varchar(25) COLLATE utf8_bin NOT NULL, `portfolio8` varchar(25) COLLATE utf8_bin NOT NULL, `portfolio9` varchar(25) COLLATE utf8_bin NOT NULL, `portfolio10` varchar(25) COLLATE utf8_bin NOT NULL, `portfolio11` varchar(25) COLLATE utf8_bin NOT NULL, `portfolio12` varchar(25) COLLATE utf8_bin NOT NULL, `portfolio13` varchar(25) COLLATE utf8_bin NOT NULL, `portfolio14` varchar(25) COLLATE utf8_bin NOT NULL, `portfolio15` varchar(25) COLLATE utf8_bin NOT NULL, `portfolio16` varchar(25) COLLATE utf8_bin NOT NULL, `portfolio17` varchar(25) COLLATE utf8_bin NOT NULL, `portfolio18` varchar(25) COLLATE utf8_bin NOT NULL, `portfolio19` varchar(25) COLLATE utf8_bin NOT NULL, `portfolio20` varchar(25) COLLATE utf8_bin NOT NULL, `portfolio21` varchar(25) COLLATE utf8_bin NOT NULL, `portfolio22` varchar(25) COLLATE utf8_bin NOT NULL, `portfolio23` varchar(25) COLLATE utf8_bin NOT NULL, `portfolio24` varchar(25) COLLATE utf8_bin NOT NULL, `videoportfolio1` varchar(50) COLLATE utf8_bin NOT NULL, `videoportfolio2` varchar(50) COLLATE utf8_bin NOT NULL, `videoportfolio3` varchar(50) COLLATE utf8_bin NOT NULL, `videoportfolio4` varchar(50) COLLATE utf8_bin NOT NULL, `videoportfolio5` varchar(50) COLLATE utf8_bin NOT NULL, `videoportfolio6` varchar(50) COLLATE utf8_bin NOT NULL, `videoportfolio7` varchar(50) COLLATE utf8_bin NOT NULL, `videoportfolio8` varchar(50) COLLATE utf8_bin NOT NULL, `videoportfolio9` varchar(50) COLLATE utf8_bin NOT NULL, `videoportfolio10` varchar(50) COLLATE utf8_bin NOT NULL, `videoportfolio11` varchar(50) COLLATE utf8_bin NOT NULL, `videoportfolio12` varchar(50) COLLATE utf8_bin NOT NULL, `firework` int(5) NOT NULL, `laser` int(5) NOT NULL, `piro` int(5) NOT NULL, `konfeti` int(5) NOT NULL, `sky` int(5) NOT NULL, `bulb` int(5) NOT NULL, `sound` int(5) NOT NULL, `light` int(5) NOT NULL, `variant1` int(5) NOT NULL, `variant2` int(5) NOT NULL, `variant3` int(5) NOT NULL, `variant4` int(5) NOT NULL, `variant5` int(5) NOT NULL, `variant6` int(5) NOT NULL, `variant7` int(5) NOT NULL, `variant8` int(5) NOT NULL, `variant9` int(5) NOT NULL, `variant10` int(5) NOT NULL, `variant11` int(5) NOT NULL, `variant12` int(5) NOT NULL, `variant13` int(5) NOT NULL, `variant14` int(5) NOT NULL, `variant15` int(5) NOT NULL, `variant16` int(5) NOT NULL, `variant17` int(5) NOT NULL, `variant18` int(5) NOT NULL, `variant19` int(5) NOT NULL, `limusins` int(5) NOT NULL, `avto` int(5) NOT NULL, `vipavto` int(5) NOT NULL, `retroavto` int(5) NOT NULL, `busses` int(5) NOT NULL, `kuharki` int(5) NOT NULL, `sweet` int(5) NOT NULL, `cake` int(5) NOT NULL, `korovai` int(5) NOT NULL, `meat` int(5) NOT NULL, `carving` int(5) NOT NULL, `furshet` int(5) NOT NULL, `fic` int(5) NOT NULL, `rus_name` text COLLATE utf8_bin NOT NULL, `rus_text` varchar(2000) COLLATE utf8_bin NOT NULL, `rus_oplata` text COLLATE utf8_bin NOT NULL, `rus_cityname` text COLLATE utf8_bin NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; Надо сделать запрос на редактирование значений, решение : Код (PHP): $q2 = "DELETE FROM users WHERE id='$id'"; // run query $result2 = mysql_query($q2); $q = "INSERT INTO `users` VALUES ('','$profesia','$obl','$city','$name','$email','$phone','$social1','$social2','$oplata','$foto','$text','$cityname','$ad','$position','$portfolio1','$portfolio2','$portfolio3','$portfolio4','$portfolio5','$portfolio6','$portfolio7','$portfolio8','$portfolio9','$portfolio10','$portfolio11','$portfolio12','$portfolio13','$portfolio14','$portfolio15','$portfolio16','$portfolio17','$portfolio18','$portfolio19','$portfolio20','$portfolio21','$portfolio22','$portfolio23','$portfolio24','$videoportfolio1','$videoportfolio2','$videoportfolio3','$videoportfolio4','$videoportfolio5','$videoportfolio6','$videoportfolio7','$videoportfolio8','$videoportfolio9','$videoportfolio10','$videoportfolio11','$videoportfolio12','$firework','$laser','$piro','$konfeti','$sky','$bulb','$sound','$light','$variant1','$variant2','$variant3','$variant4','$variant5','$variant6','$variant7','$variant8','$variant9','$variant10','$variant11','$variant12','$variant13','$variant14','$variant15','$variant16','$variant17','$variant18','$variant19','$limusins','$avto','$vipavto','$retroavto','$buses','$kuharki','$sweet','$cake','$korovai','$meat','$carving','$furshet','$fic','$rus_name','$rus_text','$rus_oplata','$rus_cityname')"; у меня не получается сделать с UPDATE почему-то((( а при таком решении создается 2 записи (тоже не пойму откуда, вторая пустая) помогите плз. Добавлено спустя 2 минуты 4 секунды: когда пробую через UPDATE по документации делать, то все что изменяю в базу приходит пустым(((
вот именно, azgardik. не можешь понять — покажи свой UPDATE, чтобы мы посмотрели что ты не так делаешь.
Код (PHP): $result = mysql_query ("UPDATE users SET profesia='$profesia', obl='$obl', city='$city', name='$name', email='$email', phone='$phone', social1='$social1', social2='$social2', oplata='$oplata', foto='$foto', text='$text', cityname='$cityname', ad='$ad', position='$position', portfolio1='$portfolio1', portfolio2='$portfolio2', portfolio3='$portfolio3', portfolio4='$portfolio4', portfolio5='$portfolio5', portfolio6='$portfolio6', portfolio7='$portfolio7', portfolio8='$portfolio8', portfolio9='$portfolio9', portfolio10='$portfolio10', portfolio11='$portfolio11', portfolio12='$portfolio12', portfolio13='$portfolio13', portfolio14='$portfolio14', portfolio15='$portfolio15', portfolio16='$portfolio16', portfolio17='$portfolio17', portfolio18='$portfolio18', portfolio19='$portfolio19', portfolio20='$portfolio20', portfolio21='$portfolio21', portfolio22='$portfolio22', portfolio23='$portfolio23', portfolio24='$portfolio24', videoportfolio1='$videoportfolio1', videoportfolio2='$videoportfolio2', videoportfolio3='$videoportfolio3', videoportfolio4='$videoportfolio4', videoportfolio5='$videoportfolio5', videoportfolio6='$videoportfolio6', videoportfolio7='$videoportfolio7', videoportfolio8='$videoportfolio8', videoportfolio9='$videoportfolio9', videoportfolio10='$videoportfolio10', videoportfolio11='$videoportfolio11', videoportfolio12='$videoportfolio12', firework='$firework', laser='$laser', piro='$piro', konfeti='$konfeti', sky='$sky', bulb='$bulb', sound='$sound', light='$light', variant1='$variant1', variant1='$variant2', variant1='$variant3', variant1='$variant4', variant1='$variant5', variant1='$variant6', variant1='$variant7', variant1='$variant8', variant1='$variant9', variant1='$variant10', variant1='$variant11', variant1='$variant12', variant1='$variant13', variant1='$variant14', variant1='$variant15', variant1='$variant16', variant1='$variant17', variant1='$variant18', variant1='$variant19', limusins='$limusins', avto='$avto', vipavto='$vipavto', retroavto='$retroavto', buses='$buses', kuharki='$kuharki', sweet='$sweet', cake='$cake', korovai='$korovai', meat='$meat', carving='$carving', furshet='$furshet', fic='$fic', rus_name='$rus_name', rus_text='$rus_text', rus_oplata='$rus_oplata', rus_cityname='$rus_cityname' WHERE id='$id'"); Добавлено спустя 1 минуту 13 секунд: запрос проверил все значения подставились а база не меняется(((( Добавлено спустя 8 минут 18 секунд: вопрос снят - спс)) PHP, JavaScript, SQL и другой код пишите внутри тегов Код ( (Unknown Language)): [b]php][/b]Тут код[b][/[/b][b]code][/b][/color]