Posted by Marcin Dobrucki on 06/29/05 13:19

Jan Stenberg wrote:
> I have a situation where I open a database connection in main script.
> Then I start a transaction, have some queries, include an another php
> file within some queries and then commiting queries in the main script.
> All queries in the main script gets committed but those in the included
> file doesn't. Why's that? Adding COMMIT query to the included file
> doesn't work either. Here are an test code which clears what I mean:
....
> Does not make any sence for me. I hope someone can help to solve this.

Did you copy&paste the script as was, or retype it? made a simple
test, and it works fine. The only thing I can think of being wrong is
the privileges for 'dbuser'.

Jan, send me email directly, no point bouncing snippets back and
forth here.

/marcin

• Next in forum: Re: use a javascript variable in php?
• Prev in forum: PHP SSH and mysql connection
• Thread view: Re: MySQL transactions doesn't work with included files?

[Reply to this message]