mySQL update statement - easy question

[wimpypenguin]

Could someone please give me a sample sql statement to update multiple fields in a table?

I want to update 3 fields in a table with values from 3 fields in a form...I've tried this a couple ways and tried looking around for the syntax, but can't seem to find it?

Thanks in advance...
Luke

[freddydoesphp]

$result = mysql_query(sprintf("UPDATE TABLENAME SET field1 = '%s', field2 = '%s', field3 = '%s' WHERE field = '%s'", $formvar1, $formvar2, $formvar3, $idvar));

[Son Nguyen]

The syntax could be found here:

http://www.mysql.com/documentation/m...section=UPDATE