Update query 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?

juergen d · Accepted Answer · 2012-04-13 20:37:59Z

4

Use this syntax for update statements:

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

You got it mixed with insert statement I guess.

answered Apr 13, 2012 at 20:37

juergen d

205k40 gold badges303 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

octern Over a year ago

This is correct. The syntax the OP used is for INSERT and doesn't work for UPDATE.

Jeff Allen · Accepted Answer · 2012-04-13 20:37:30Z

0

It looks like your ID is empty (...VALUES ('',...). Should there be an ID there?

answered Apr 13, 2012 at 20:37

Jeff Allen

17.6k9 gold badges52 silver badges71 bronze badges

Comments

Abdyresul Charyev · Accepted Answer · 2012-04-13 20:39:09Z

0

Your $id seems to be empty or not defined yet. Read mysql.error() up to the end.

answered Apr 13, 2012 at 20:39

Abdyresul Charyev

581 silver badge9 bronze badges

Comments

norbi771 · Accepted Answer · 2012-04-13 20:39:56Z

0

The update query has different syntax, something like that:

UPDATE `outgoings` SET user_id='$uid', bill='$bill' WHERE id = '$id'

answered Apr 13, 2012 at 20:39

norbi771

8342 gold badges12 silver badges29 bronze badges

Collectives™ on Stack Overflow

Update query MySQL PHP

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related