DiigIT | IT Community
No Profile Image
Welcome Guest
New User? Register | Login

Multiple transactions in mysql

By: rekha singh | 04 Feb 2010 1:49 am

Dear all

I'm using some multiple transactions to complete a task. My coding is given below:

mysql_query( "BEGIN");           
            mysql_query( $qrysent) or die('Could not delete. Try after some time.');           
            mysql_query( $qrydel) or  mysql_query( "ROLLBACK" );           
            mysql_query( $DelUsrQry) or mysql_query( "ROLLBACK" ) ;
mysql_query( "COMMIT") ;

It is working fine. But I have to check whether it is committed or not. Accordingly I have to proceed the coding.

Pls help me how me how to do it?

Thanks,
 

Comments

Leave a comment

Enter the text in the image
img
Can't read?
Type the characters you see in the picture below.


Close Move