[ pela @ 16.01.2009. 17:32 ] @
Evo vec 2 sata buljim u ovo i nije mi jasno gde gresim? MySql verizja: 5.0.67 Php verzija : 5.2.6 Code: CREATE TABLE `bands` ( `id` varchar(50) collate utf8_unicode_ci NOT NULL, `name` varchar(255) collate utf8_unicode_ci NOT NULL, `abstract` varchar(255) collate utf8_unicode_ci default NULL, `desc` text collate utf8_unicode_ci, `img_filename` varchar(255) collate utf8_unicode_ci default NULL, PRIMARY KEY (`id`,`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; ----------------------------------------------------------------------- $uid = 123; $name = "aha"; $abstract = "ahaaha"; $desc = "ahaahaaha"; ----------------------------------------------------------------------- $result = mysql_query("UPDATE bands SET name='$name',abstract='$abstract', desc='$desc' WHERE id='$uid'"); if (!$result) { die('greska: ' . mysql_error()); } Citat: greska: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near desc='ahaahaaha' WHERE id='123' at line 1 Edit by Dakipro: Izmena naslova [Ovu poruku je menjao dakipro dana 17.01.2009. u 13:25 GMT+1] |