all you have to do is put one query per line in the file, it may be hard to read, but who cares.
and then it is as simple as. $contents = file("sql.txt"); //file function reads file into array while (list ($qry)) = each($contents)) { mysql_query($qry); } Just a thought.... Jeff "Bruce Vander Werf" To: <[EMAIL PROTECTED]> <brucev@cyberl cc: ink.com> Subject: RE: [PHP-DB] Executing Queries from a File Using PHP 06/13/2002 08:39 AM Please respond to brucev Thanks. Since it would take me forever to write, and I don't know thing well enough to make sure I have all the possibilities covered, I was hoping there was some source code somewhere I can use. --Bruce -----Original Message----- From: Jason Wong [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 11:34 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Executing Queries from a File Using PHP On Thursday 13 June 2002 10:48, Bruce Vander Werf wrote: > Is there a PHP routine anywhere to execute a series of MySQL queries in a > text file? > > I know how to do this via the command line or by using PHPMyAdmin, but I > need to do it in my own PHP script, and some of the queries span more than > one line. There are no built-in functions to do so. You need to read in the file yourself, parse it appropriately then send the queries to mysql. -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* Thank you for observing all safety precautions. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php