Multiple transactions in mysql

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,
 

Hi,

Hope This Link image will help you some more,

http://3.bp. blogspot. com/_0STx- FLyzOI/RugzBic- CnI/AAAAAAAAAEw/ uYPtakxpKcY/ s1600-h/untitled .bmp