Executing MYSQL external files from PHP

[HughbertD]

I have a file I have created with a bunch of regular expressions to create a load of sql insert statements, how can I execute this from PHP?

 

Thanks for any help

 

I had been trying to do this using DBD:Mysql in Perl but I can't get the damn thing installed! If anyone knows the specifics of how to do that, that would be great too!

 

Regards

Hugh

[jaymc]

put them in an array called $whatever

 

then do

 

foreach ($whatever as $whatever) {

 

mysql_query($whatever);

 

}

[trq]

Your first question: What do regular expressions have to do with sql statements?

 

Your second question: Nothing to do with php.

[HughbertD]

The regular expressions; I was just saying that was how I got my file with sql statements in. I mentioned it to demonstrate the file needs to be read in by PHP from an external source.

 

The second question was definitely a naughty by me (sorry) just in case someone had had the same problem as me and knew any solutions.