MySql verizja: 5.0.67
Php verzija : 5.2.6
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());
}
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]