Send multiple SQL statements using PEAR:DB – how?

[mattp52]

I've written some recursive code which generates a series of INSERT() statements after parsing XML, calculating shared key vals between tables as it goes. Now when I come to run the thing on the database using the PEAR:😃B library it won't 'work because I have multiple SQL statements in my query.

Is there a way (using PEAR:😃😎 to send a SQL file to the database so multiple queries can be processed or do I need to save an array structure and use DB->executeMultiple()?

Hope you can help.
Cheers,
Matt

[thorpe]

You will need to execute multiple statements. From what I remember, MySql itself does not support multiple queries, though I may be wrong.... been a long time since Iv'e used MySql.