Hi,
I am using transactions on a piece of code whose structure is somewhat like this
if ( condition )
{
mysqli_autocommit($fcon, false);
if ( condition )
{ $query " ";
if ( condition )
{ $query " ";
if ( condition )
{ $make = makeTable(); // where this is a function which creates a table and uses a query like INSERT into ... to create an entry in a table
if ( $make == true)
{ $query " ";
if ( condition )
{ $query " ";
}
else
else
and so on ending all else.
The problem is that the function call to makeTable prevents the roll back beyond that point. Please can someone tell me if and how it would be possible to roll back all the way to the defined starting point at the very beginning of the code block.
Thanks all for any help, comments, suggestions.