During a payment request, I want to insert addition information into the Magento database. I want this additional information to be inserted regardless of the transaction result for the main database connection.
I believe the only way to do this is to create a second connection to the database, as MySQL doesn't allow nested transactions. How can create this second database connection in Magento OR is there another way to solve my problem?
$table = Mage::getSingleton('core/resource')->getTableName($name); Mage::getSingleton('core/resource')->getConnection('core_write')->insert($table, $array);