MULIPLE INSERTS ExecuteRemoteQuery

[mariolu]

PLEASE HELP WITH MULTIPLE INSERTS FOR ExecuteRemoteQuery COMMAND.

I WANT TO INSERT MULTIPLE RECORDS IN SINGLE COMMAND!!

I HAVE TRIED THE FOLLOWING WITH

IT ONLY WORKS WITH ONE INSERT COMMAND.

IS MY SYNTAX NOT CORRECT IN ANY ONE OF THESE COMMANDS

OPTION 1
"ExecuteRemoteQuery(INSERT INTO...VALUES(...);INSERT INTO...VALUES(...)


OPTION 2
"ExecuteRemoteQuery(INSERT INTO...VALUES(...), VALUES(...)

OPTION 3
"ExecuteRemoteQuery(START TRANSACTION; INSERT INTO...VALUES(...);INSERT INTO...VALUES(...);COMMIT;_

PLEASE ADVISE!!!

 

[Erel]

You should not write everything in upper case. It is considered SHOUTING...

The problem is that the PHP function mysql_query doesn't support multiple queries. If you know some PHP then you can change the PHP script to accept values and then issue the queries in the script.

 

[mariolu]

follow up

sorry for the upper case, not screaming at all
i am not to familiar with php!!

i have tried sending series of single command inserts with a loop, when i sending them in debug mode, they insert with no issues , as i am stepping through each line, (i guess because there is a delay between each command)

when i send them by running in real time, only the first inserts gets executed, do i need a additional command, or do i need a pause, please advise!!!

thanks

 

[Erel]

Without modifying the PHP script, you will need to send each query on its own.