更新查询MySQL PHP

Question

im trying to update my table using the following query...

 $query = mysql_query("UPDATE `outgoings` (id, user_id, bill, bill_name, bill_description, bill_colour ) VALUES ('$id', '$uid', '$bill', '$billname', '$billdescription', '$billcolour') WHERE id = '$id'") or die(mysql_error());

It returns...

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 '(id, user_id, bill, bill_name, bill_description, bill_colour ) VALUES ('', '8464' at line 1

Ive tried removing ' around my variables and googling for alternative methods but cant seem to figutre out what imdoing wrong?

Answer 1

Use this syntax for update statements:

UPDATE `outgoings` set id = '$id', user_id = '$uid' ... where ...

You got it mixed with insert statement I guess.