running multiple MySQL queries in batch from PHP

[davidklonski]

Hello

I have an SQL file which contains numerous queries which I use in batch mode to initialize the database.

I would like to run this file from PHP.
The problem is that the file contains numerous queries while mysql_query accepts a single query.

Is there a way to run a batch of queries from PHP?
I am talking about commands like:
drop table, create table, insert...

thanks in advance

[Thora_Fan]

Best way to do it would be to load the SQL file into an array, cycle through the array, and execute a mysql_query() on each cycle. I would only suggest this if your SQL file isn't TOO big.