Posted by Jerry Stuckle on 08/02/07 13:17

João Morais wrote:
>> 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.
>

Commit/Rollback are SQL commands, not PHP. If you need to learn more
about how to use them, you need a SQL newsgroup. Their use is not
dependent on PHP or any other language. They work the same from the
MySQL command line, for instance.

mysql_query(), etc. are PHP functions, and are appropriate for this group.

>> 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.
>

As I said - I'm not sure on that. You need to check the MySQL
newsgroups as to what MySQL does in this case.

>
>> There are other things you will need to consider with COMMIT and
>> ROLLBACK.
>
> What things?
>

See comp.databases.mysql.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]