CI's mysql transction question

[eluser]gtech[/eluser]
you can start and stop your transaction as you describe no problems (make sure you turn db_debug to FALSE or transactions do not work). The only problem you will find is when you call a transaction within a transaction, e.g. if payforgame_tmp had a trans_start and trans_complete the transaction would not work.


Even though the transaction will work in the above code, I personally think it makes more sense to engineer your code so that the transactions are left in the model (you can call functions that are in the same model).