Mysql start-complete

You only need the trans_start and trans_complete functions if you want to update or insert records in multiple tables. If one of the updates or inserts fails, the entire transaction will be rolled back.
If you retrieve records by a unique ID, the result can only be one record (row).

PHP Code:

return $result->row(); 


will do.

ok thanks alot for the info ill surely be back