UPDATE multiple values - proper syntax? 1

[frozenpeas]

Hello,

I can't seem to figure out how to update multiple db entries in one query. Here are the methods I have tried (the bolded query works):

$query = "UPDATE sylvie_links SET link='$link',SET text='$text',SET type='$type',SET comment='$comment' WHERE id='$id'";

$query = "UPDATE sylvie_links SET link='$link' SET text='$text' SET type='$type' SET comment='$comment' WHERE id='$id'";

[b]$query = "UPDATE sylvie_links SET link='$link' WHERE id='$id'";[/b]

Thanks.

frozenpeas

 

[frozenpeas]

Okay, got it. I don't know why I thought I needed to use SET for *each* value.

$query = "UPDATE sylvie_links SET link='$link',text='$text',type='$type',comment='$comment' WHERE id='$id'";

Thanks.

frozenpeas