Fixed: Rollback transactions in PHP ADODB

gistfile1.php

<?php
/*
 * Problem: RollbackTrans() command doesn't work
 *
 * FIX:
 * The problem happens whenever I use the "mysql" driver to connect in the database
 * To fix it, I used the "mysqli" driver in ADODB Connection
 * 
 * The next example is the correct use of Transactions in ADODB
 */

$DB = &ADONewConnection("mysqli");
$DB->Connect('hostname', 'db_user', 'db_pass', 'db_name');

$DB->BeginTrans();
$DB->Execute(" SQL QUERY ");
$DB->Execute(" SQL QUERY ");

// Revert all SQL queries:
$DB->RollbackTrans();