Multiple update syntax

[leedude]

is there a way i can selectively update columns like i can with the insert command:

update table1 set (page,title,dsc) = (1,"Page 1","This is Page 1") where id = 4;

(this is excluding the id column from the update).
This produces an error, is there a way i can do this like i can insert data:?

insert into table1 (page,title,dsc) values (1,"Page 1","This is Page 1")

plz help.

[AndyB]

[code]$query = "UPDATE table1 SET (page,title,doc) VALUES('1','Page 1','This is Page 1') where id = '4')";[/code]

[fenway]

Really?!? I didn't know that syntax was even possible.

[leedude]

thankyou thankyou thankyou!!!!!!!!!!!!!!!!!!

;D ;D ;D ;D ;D ;D ;D ;D

[leedude]

or actually not...
It still brings an error.  :-\

And i cant help noticing that there appears to be an extra close-bracket at the end.

[fenway]

Well, you can always try the old-fashioned way:

[code]
$query = "UPDATE table1 SET page = '1', title = 'Page 1' , doc = 'This is Page 1' where id = '4'";
[/code]