Changing a VARCHAR with MySQL PHP?

Question

$db->query("UPDATE `".MLS_PREFIX."users` SET `logo` = $icon WHERE `userid` = $id");

The query thing works fine, but logo doesn't change. It is a VARCHAR and I made sure $icon is a string. It does not change, but I have the same query somewhere else just changing a INT and it works fine.

Answer 1

Try This

$db->query("UPDATE `".MLS_PREFIX."users` SET `logo` = '$icon' WHERE `userid` = $id");

Answer 2

Use this query:

$db->query("UPDATE `".MLS_PREFIX."users` SET `logo` = {'$icon'} WHERE `userid` = {'$id'}");