I am already using multiple MySQL connections throughout the project, as well as select_db() in some other places.
My question specifically revolved around if anyone can explain why select_db() implicitly committed the transaction, and then when done again to return back to the initial database, it did a rollback instead of commit.