codeigniter transactions - trans_start trans_complete trans_status
What transactions are looking for successful queries. Your query
$this->db->query("SELECT * FROM TABLE2 WHERE ID = 55");is a proper query and it runs accordingly and return 0 rows. Not returning any rows does not mean that the query failed to run.
If you provide your example for the update queries, it might shed more light on the matter.
Use this procedure. It work somehow ^_^
$this->db->trans_start(); $this->db->query("UPDATE `TABLE1` SET `NAME` = 'AAA' WHERE `ID` = '1'"); $this->db->query("UPDATE `TABLE2` SET `NAME` = 'BBB' WHERE `ID` = '2'");if($this->db->trans_status() === FALSE){// Check if transaction result successful $this->db->trans_rollback(); echo "<BR>------- TRANS FAILED -------</BR>";}else{ $this->db->trans_complete(); echo "<BR>------- TRANS SUCCESS -------</BR>";}