I've been doing some research and have not found a complete answer if I can use mysqli_multi_query that may contain both Updates/Deletes, while using mysql_rollback in the event that one of the queries fails. Does anyone know if this can be done? If so, any simple example I could build off of?
The only examples and information I have seen is simple query by query with auto commit disabled, then committing at the end, with the option of rollback in the event of an issue.