Sending multiple queries to MySQL (sorry, hit send by accident!)

[Andy Hall]

Hi,

I have a situation where, within a PHP loop, I am creating over one hundred SQL 
statement (INSERTS and UPDATES).

Would it cut any overhead to send 20 ";" seperated queries in one mysql_query() 
statement, and therefore only execute mysql_query() 5 times for 100 statements, as 
opposed to sending each statement individually?

So, 

mysql_query("INSERT 1", "UPDATE 1...", "INSERT 2...", "UPDATE 2..");

or:

mysql_query("INSERT 1");
mysql_query("UPDATE 1...");
mysql_query("INSERT 2...");
mysql_query("UPDATE 2..");

Do you save by not making as many connections?

Thanks

Andy.