Why can't I rollback!?

[dave_biscuits]

Hi Everyone,

 

I'm trying  to do a simple procedure: begin, update, rollback ... only problem is it keeps committing!!

 

I'm tearing my hair out here ... tried it numerous ways with no success so far. Current code looks like:

 

      /* turn autocommit off */
      mysqli_autocommit($link, FALSE);
      
      mysqli_query($link, "UPDATE customer SET ".$update." WHERE customer_uid = '".$data['customer_uid']."';");

      mysqli_rollback($link);

 

But it keeps updating the database despite my efforts.

 

PHP5, Apache 2.2, FreeBSD 7.0 ... pretty much out of the box setup config wise.

 

Any ideas??

 

Thanks, Dave

 

 

 

 

[veridicus]

Are your tables MyISAM?  Non-transactional table types can only auto-commit and won't show any error if you try to rollback.

[dave_biscuits]

Nuts, looks like it is (mysql ver 5.1) ... so no rollbacks, ouch that sucks

 

(Edit: read up on switching to innodb, all good now )

 

Appreciate the help, cheers.