Great! thanks for your help. -Steve.
-----Original Message----- From: Michael Bretterklieber [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 9:11 AM To: Php-Db (E-mail) Subject: Re: [PHP-DB] 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:[EMAIL PROTECTED]] > 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 [EMAIL PROTECTED] homepage: http://www.jawa.at --------- privat ----------- E-mail: [EMAIL PROTECTED] 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php