insert in several tables

Anon

I need to isert into MySQL SQL like this:

$sql = "insert into AAA (AAA_ID,AAA) values ('1','qweqwe'); insert into BBB (BBB_ID,BB😎 values ('2','rtyrty');";
mysql_query($sql);

But it does not work. I need to make several insert queries at ones (inserting one query works but when they are more it does not works). I know that I can split them by ");" and loop with FOR, but there must be any way to make it only with php functions.

Please advise

Anon

I had such type of problem. For the moment I came with an idea of excuting each query separately but at the same time, i.e,

$query1 = insert................
$query2 = insert.............
$result1 = mysql_query($query1)
$result2 = mysql_query($query2)

Until ....

Anon

I made it this way:
$alltables = array('LANGUAGE','ENCODING','HEADER','SECTION');

for($i=0;$i<count($alltables);$i++){ $query="delete from ".$alltables[$i];
mysql_query($query) or die(mysql_error());
}

but if I can insert all scripts through DOS prompt why can't I do the same with php?

[deleted]

Because that's the way it works.

You can only execute one query at a time, and that's that.

And why is it like that?
Because if you were able to execute more than one query at a time, you would
1. have no way of telling wether a query failed.
2. have to check each and every parameter to make sure it doesn't contain a hidden query that would drop your database
3. get into serious sh*t if one of thw queries failed and the rest worked.

A forum, a FAQ, email notification, what else do you need?