Basic MySQL Error using UPDATE query

Question

I have no idea what I've done wrong, I've tried a lot of different things so far, reworking the statement, etc, but nothing seems to work.

I'm getting this error:

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 'SET content='this is content', active='1' WHERE id='1'' at line 1

And this is the query I'm using:

UPDATE Pages SET title='$title', SET content='$content', active='$active' 
WHERE id='$id'

I've checked to make sure that it's not what's being inserted that is the problem.

Aurelio De Rosa · Accepted Answer · 2011-10-30 12:42:30Z

2

Delete the second SET into your query.

You have:

SET title='$title', SET content='$content'

answered Oct 30, 2011 at 12:42

Aurelio De Rosa

22.2k8 gold badges51 silver badges71 bronze badges

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

1 Comment

John Over a year ago

Thank you so much! How on earth did I miss that!

Collectives™ on Stack Overflow

Basic MySQL Error using UPDATE query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related