Problem running multi-line sql from php

[dave5398]

I just want to insert a bunch of records into a table with fields, let's say, A and B. I can do this from phpAdmin with a statement like:

INSERT INTO table SET A=1,B=2;
INSERT INTO table SET A=9,B=24;

and so on which works fine.

When I generate a similar query with a loop and create a variable $sql using something like

for ($j=0;$j<something;$j++){
$sql .="INSERT INTO table SET A=$a,B=$b;\r\n";
}

the sql fails and it says I have an error near the second insert. I have tried all combinations of terminations, with and without \r, \n etc but nothing works. What am I doing wrong??

Dave

[rincewind456]

I assume you're using [man]mysql_query/man in which case it wont work as this function doesn't support multiple queries.

If you have the MYSQLI extension enabled, then you can use [man]mysqli_multi_query/man. Which as the name suggests does support multiple queries.

[dave5398]

Many thanks - I never would have worked that one out.

Dave

[rincewind456]

No problem, don't forget to mark this resolved.