Update SQL question

[Pellefant]

Hello!

I have tried the manual with no luck.

What might be wrong here please?

$Query = "UPDATE klas SET(datum,type,artist,title,rating,coverlink,author,authoremail,reviewtext,link1,link2,approved,clicks) values ('$datum', '$typ',  '$artist', '$title', '$rating', '$coverlink', '$author', '$authoremail', '$reviewtext', '$link1', '$link2', '1','0') WHERE id=$id";

The error msg is:
$Query = "UPDATE klas SET(datum,type,artist,title,rating,coverlink,author,authoremail,reviewtext,link1,link2,approved,clicks) values ('$datum', '$typ', '$artist', '$title', '$rating', '$coverlink', '$author', '$authoremail', '$reviewtext', '$link1', '$link2', '1','0') WHERE id=$id";

😕

[ir4z0r]

wrong Syntax, use:

INSERT INTO table (col1, col2) VALUES ('v1','v2')

UPDATE table SET col1='v1', col2='v2'

[Pellefant]

Works wounderful!

Thank you.