|
|
Posted by Joγo Morais on 08/02/07 13:03
> How to use COMMIT/ROLLBACK is more of a SQL question and belongs in
> comp.lang.mysql.
Sorry but I dont agree.. the question is not how to use commit/
rollback in a general way, but with PHP. If I only used MySQL i
wouldnt have this problem at all.
> I don't think it's a good idea to use die() - is that what you want your
> client to see?
I just used die as an example of abort/report failure, I wont use this
in my final script.
>Additionally, I'm not sure die() will roll back your transaction.
For what I understood, (and I may be wrong), the data will only be
saved if COMMIT is done. So if one of the first 3 queries fail, no
COMMIT will be done, then no data will be saved.
Same occurs if first 3 queries are made with success, and the last one
fails.
> There are other things you will need to consider with COMMIT and
> ROLLBACK.
What things?
Navigation:
[Reply to this message]
|