Multiple Table INSERT Queries in single SQL Statement [duplicate]

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 - stackoverflow.com/questions/10471757/… — Caffeinated
– Caffeinated, Commented Mar 13, 2013 at 2:24

Amir · Accepted Answer · 2013-03-13 05:25:15Z

0

$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());

answered Mar 13, 2013 at 5:25

Amir

4,1314 gold badges18 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Multiple Table INSERT Queries in single SQL Statement [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related