REACTOR $this->db->set() not working in update

[eluser]Jaketoolson[/eluser]
Wouldn't it be beneficial if you were to first check the query to make sure its valid, without using CI's DB? Doesn't anyone use MYSQL Query Browsers, phpMyAdmin, or other interfaces to interact with their databases? If this were me, and I had this problem, I'd first try writing the query out to see if it works.

Code:

"UPDATE table SET field=$data WHERE id=$id";

If this still updates everything then it's your DB structure.