PHP MySQL update set

Question

I'm trying to update a row, but only to append a new word at words:

mysql_query("UPDATE list SET words = words', $new_word' WHERE id = $id_row");

It's not working, I've no other ideas..

Sougata Bose · Accepted Answer · 2015-02-05 12:48:41Z

1

Try with CONCAT-

"UPDATE list SET words = CONCAT(words, '$new_word') WHERE id = $id_row"

Use mysqli or PDO. mysql is deprecated.

answered Feb 5, 2015 at 12:48

Sougata Bose

31.8k8 gold badges52 silver badges89 bronze badges

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

1 Answer 1