I think it's better to split the SQL into pieces line 1: create table .... line 2: insert into ..... $sql = 'create table....' $sql = 'insert into ...' 2005/7/13, Shaw, Chris - Accenture <cshaw@xxxxxxxxxx>: > > > Can you use mysqli_multi_query for mysql in php5? > > hth > > -----Original Message----- > From: babu [mailto:garavindbabu@xxxxxxxxxxx] > Sent: 13 July 2005 16:39 > To: php-general@xxxxxxxxxxxxx > Subject: How to run .sql files using php > > > Hi , > > i have a set of queries which i have placed them in one .sql file.i want > to > run this file using php's mssql and oracle(oci) functions. > any idea pls. > > thanks. > babu > > > > --------------------------------- > How much free photo storage do you get? Store your holiday snaps for FREE > with Yahoo! Photos. Get Yahoo! Photos > > > ************************ > > This message has been delivered to the Internet by the Revenue Internet > e-mail service > > ************************* > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >