Insert into 2 tables.

[Anonymous]

I need to insert some data into 2 tables at the same time :

$q="insert into table_A (Data1, Data2) values ('$Data1', '$Data2')";

$q="insert into table_B (Data2, Data3) values ('$Data2', '$Data3)";

What should be the right querry ?
The same question but for DELETE.

Thanks for your help,
Erick.

 

[Anonymous]

Try this one -->

mysql_select_db($database,$connection); 
////////////////////////////////////////////////////////
$sql_one = "insert into table_A (Data1, Data2) values ('$Data1', '$Data2')"; 
$sql_two = "insert into table_B (Data2, Data3) values ('$Data2', '$Data3)"; 
////////////////////////////////////////////////////////
$result_one=mysql_query($sql_one , $connection); 
$result_two=mysql_query($sql_two , $connection);

bye!