Transaction (Begin,Commit,RollBack) เช็คการส่งเมล์ และ insert เข้า ฐานข้อมูล

<?
include('conn_mysql.php');

//*** Start Transaction ***//
mysql_query("BEGIN");

// ตารางที่ 1
$sql1 = "insert into booking_ticket (ticketID,bookingID,customerID,packageID,price,updateDate,enterDate) 
VALUES ('"."T"."$strNextSeq11','"."B"."$strNextSeq50','$customerID','$package','$price',now(),'$enterDate');";
		$objQuery1 = mysql_query($sql1)or die(mysql_error());
		
// ตารางที่ 2
$sql2 = "insert into booking_customer_condition (ticketID,condition_text,updateDate,enterDate) 
VALUES ('"."T"."$strNextSeq11','$condition_text',now(),'$enterDate');";
		$objQuery2 = mysql_query($sql2)or die(mysql_error());
		
		
// sant E-mail
	$name_blu = "Blunagaracha";
	$strTo =  "[email protected]";
	$strSubject = "Booking invoices";
	$txtFormEmail = "[email protected]";
	$strHeader = "";
	$strHeader  = 'MIME-Version: 1.0' . "\r\n";
	$strHeader = "Content-type: text/html; charset=UTF-8\n"; 
	$strHeader .= "From: Info<".$txtFormEmail.">\nReply-To: ".$txtFormEmail."\r\n";
	$strMessage = "good";
	
	$flgSend = @mail($strTo,$strSubject,$strMessage,$strHeader);	
		
		
if(($objQuery1) and ($objQuery2) and ($flgSend))
{
	//*** Commit Transaction ***//
	mysql_query("COMMIT");
	echo "Save Done.";
}
else
{
	//*** RollBack Transaction ***//
	mysql_query("ROLLBACK");
	echo "Error Save [".$objQuery1.$objQuery2."]";
}

?>