[PHP-DB] Re: db sql issue from var

[Adam Royle]

Hi Dave,

Load the data from the text file into a variable (eg, $fileContents)

Then split the file into an array and run every sql statement.

The following code should work...

Adam


$arrSQL = explode(";",$fileContents);

for ($i=0;$i<count($arrSQL);$i++){
    if ($arrSQL[$i]){
        mysql_query($arrSQL[$i]);
    }

}