Thanks for all your replies.

<Jason Lotito>
MySQL does support transactions.
Look into www.innodb.com
</Jason Lotito>

Thanks -- I discovered my MySQL book is a bit out of date after my post.

Since then, I've read that using innodb adds a 5x hit to performance. 
One book I read actually argued for straight table locking with MyISAM.

<Christopher Scollo>
Here's a tutorial for you:
http://hotwired.lycos.com/webmonkey/backend/databases/tutorials/tutorial2
.html
</Christopher Scollo>

Thanks!

<>
The problem with that is, you still don't have transaction support on 
your DB.  Even if you code it in PHP, data loss can still happen on your 
database.
</>

I understand. What I'm really looking for is a clean way to handle 
errors when adding related records to multiple tables. I don't need a 
high level of transaction support -- if I did, I wouldn't be using 
MySQL.

dsb

***************************************       
David Scott-Bigsby
Product Manager, Web Site and PEDN

PureEdge Solutions
The Leader in Secure XML e-Forms

v:250-708-8145  f:250-708-8010
1-888-517-2675   www.PureEdge.com
***************************************


> -----Original Message-----
> From: Adam Lang [mailto:aalang@r...]
> Sent: Monday, June 17, 2002 5:54 AM
> To: professional php
> Subject: [pro_php] Re: transactions in MySQL
>
>
> In your PHP code?
>
> The problem with that is, you still don't have transaction
> support on your
> DB.  Even if you code it in PHP, data loss can still happen on your
> database.
>
> MySQL is still gonna have to process it one query at a time,
> no matter how
> you code it in PHP.  So if after query two, the network cable
> gets pulled,
> the 5 queries after it still won't be submitted, but the
> first 2 queries
> will be.
>
> Adam Lang
> Systems Engineer
> Rutgers Casualty Insurance Company
> http://www.rutgersinsurance.com
> ----- Original Message -----
> From: "David Scott-Bigsby" <DScott-Bigsby@P...>
> To: "professional php" <pro_php@p...>
> Sent: Friday, June 14, 2002 7:19 PM
> Subject: [pro_php] transactions in MySQL
>
>
> > Hey all,
> >
> > I know MySQL doesn't support transactions, but I'm willing
> to build the
> commit/rollback logic in my code.
> >
> > That said, I'd rather use someone else's code.
> >
> > Can anyone recommend a public code library which does this?
> >
> > thanks,
> >
> > dsb
> >
> > ***************************************
> > David Scott-Bigsby
> > Product Manager, Web Site and PEDN
> >
> > PureEdge Solutions
> > The Leader in Secure XML e-Forms
> >
> > v:250-708-8145  f:250-708-8010
> > 1-888-517-2675   www.PureEdge.com
> > ***************************************
> >
> >
>
>
>
>
>