Possible?

[drbigfresh]

I know I used to be able to do this in asp and sql, but I hven't been able to get it to work in PHP and MySQL....

 

Is there some way to build a long query using new lines, and then execute it once...

 

For example:

 

$sql = "insert into test (animal) values ('dog')\n";

$sql = $sql . "insert into invoices (invoicenos) values ('123')\n";

$sql = $sql . "insert into users (email) values ('[email protected]')\n";

 

$db->Execute($sql) or die($db->ErrorMsg());

 

in asp/sql I could do it by seperating the queries with & VCBRLF and SQL would interpret each query separately....

 

 

Thanks!

[teng84]

have you tried it?

 

[mezise]

Hi,

yes, it is possible, but using Improved MySQL Extension function mysqli_multi_query() or its OO version. The only difference is that you need to use semicolon as a separator. You will find the details on this manual page: http://www.php.net/mysqli_multi_query .

 

Michal

[fenway]

Why on earth would you want to do this?