In my LAMP application (using CodeIgniter), I have a call to $this->db->update... that generates a SQL like the following:\[code\]UPDATE `MyTable` SET `MyProcess` = 5 WHERE `Id` = 1\[/code\]The problem is that this seems to work intermittently -- and I currently have no idea what might be wrong. Is there anything about MySQL I need to know about when trying to update? I'm adding & updating records a lot (but probably no more than one query every 5 seconds). When I run the query in phpMyAdmin, it works fine.Suggestions on how to troubleshoot this?
SQL UPDATE not working?
- Thread starter vB1
- Start date