Re: Innodb and transactions.

Hi, use InnoDB, because InnoDB supports row-level locking, and InnoDB also supports referential-integrity, bye, Steve Bradwell schrieb:

So should I be using Innodb tables or BDB tables? Thanks, Steve. -----Original Message----- From: Michael Bretterklieber [mailto:mbretter@jawa.at] Sent: Friday, June 21, 2002 2:49 AM To: Php-Db (E-mail) Subject: Re: [PHP-DB] Innodb and transactions. Hi, you have to do something like this: mysql_query('SET AUTOCOMMIT=0'); .... mysql_query('COMMIT'); or mysql_query('ROLLBACK'); mysql_query('SET AUTOCOMMIT=1'); bye, Steve Bradwell schrieb:

Hi all, I have just figured out and set up my Innodb on my mysql server so I can

use

transactions Begin, commit, rollback. I'm now looking for examples on how

to

do this with php. I hit the php site and the best I could find was fbsql_commit etc... is this what I'm looking for? There's no documentation yet. I'm using php4 with mysql 3.23.49-max, and my tables are Innodb. I appologize if my lingo is somewhat confusing or just wrong but I'm

pretty

new to this stuff. Any input or examples would be greatly appreciated. Thanks, Steve.

-- -------------------------------------- Michael Bretterklieber LCP JAWA Management Software GmbH Liebenauer Hauptstr. 200 A-8041 GRAZ Tel: ++43-(0)316-403274-12 Fax: ++43-(0)316-403274-10 GSM: ++43-(0)676-93 96 698 Michael.Bretterklieber@jawa.at homepage: http://www.jawa.at --------- privat ----------- E-mail: mbretter@inode.at homepage: http://www.inode.at/mbretter -------------------------------------- "...the number of UNIX installations has grown to 10, with more expected..." - Dennis Ritchie and Ken Thompson, June 1972