Multiple Table INSERT Queries in single SQL Statement

Question

I am trying to insert queries into multiple tables using the following code. I have tried without the TRANSACTION and it will not work, individually they work. Any help would be much appreciated.
Thanks in advance.

$query = mysql_query("BEGIN;  
INSERT INTO `uc` (`ANO`, `CNO`, `P`) VALUES ('$ano', '$cno', '$p');  
INSERT INTO `ct` (`ANO`, `CNO`, `RNO`) VALUES ('$ano','$cno','$rno');  
COMMIT;");   

$query_run = mysql_query($query);

Ah, multiple tables - http://stackoverflow.com/questions/10471757/insert-rows-into-multiple-tables-in-a-single-query-selecting-from-an-involved-t — Caffeinated, Mar 13 '13 at 02:24

score 0 · Accepted Answer · answered Mar 13 '13 at 05:25

$query = "BEGIN";
mysql_query($query) or die (mysql_error());

$query = "INSERT INTO `uc` (`ANO`, `CNO`, `P`) VALUES ('$ano', '$cno', '$p')";
mysql_query($query) or die (mysql_error());

$query = "INSERT INTO `ct` (`ANO`, `CNO`, `RNO`) VALUES ('$ano','$cno','$rno')";
mysql_query($query) or die (mysql_error());

$query = "COMMIT";
mysql_query($query) or die (mysql_error());

Multiple Table INSERT Queries in single SQL Statement

1 Answers1