Thanks,
that's the problem, their using MYISAM tables, not Innodb or BDB table handlers
so it won't work! Damn,.. guess that answer that question.. :)
>> Tue, 14 Aug 2001 15:12:48 -0400, [EMAIL PROTECTED] wrote:
>>
>>Which version of MySQL? In the CREATE TABLE statement for members, did you
>>specify the table type that uses transactions? (Can't remember what it is right
>>this second.) Does your actual code execute more than one statement inside the
>>transaction? If not, there's not much point to using it.
>>
>>The canonical example for using transactions looks something like this (after
>>setting AutoCommit to 0 and preparing $sth):
>>
>> eval {
>> $sth->execute($pay, $user);
>> # other SQL statements
>> $dbh->commit;
>> };
>> if ($@) {
>> $dbh->rollback;
>> # other error handling: unlock the table, log a warning, etc.
>> }
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=