transaction between two pages

[m_vito]

I can insert given in one table in the first page and to make the rollback or commit in the second one?
how I must make?
Tanks, Vito

[bastien]

no....you are asking about transactions in a database...this must all occur in one segment of code..

begin trans
insert
if insert fails
rollback
else
commit
end if
end trans

also be aware that not all databases support transactions. check your DB documentation for specifics.

hth
Bastien

[m_vito]

hi,
my db is oracle but when I write BEGIN TRANS in my php-code I have error...
I open my db by OCI command and I use oci_logon or oci_plogon but I have same results.
My questions is: it's possible make insert in first page and rollback o submit in second page?
Tanks
Vito