Re: excuting several sql statements in one time

This is more of a MySQL question, but: Actually, as of MySQL version 3.22.5, INSERT statements can have multiple value lists. In your case, this would be $query =

      "INSERT INTO com VALUES ".
      "('pentium'), ('amd')";

mysql_query($query, $dbconnect) or die(mysql_error()); Also, you don't need a trailing ';' on the SQL query statement (you DO need it, of course, at the end of the PHP statement). See http://www.mysql.com/doc/I/N/INSERT.html for more information. -steve At 11:58 AM +0200 9/20/01, _lallous wrote:

No you can't! I wrote a simple routine for the task! you might want to view it from: http://www.kameelah.org/eassoft/php_files/sql2php.php.txt just take the parse_sql_stream($all) which returns an array that have all the statments to be passed to mysql_query() this script is usefull when you have a huge .SQL file that you want to execute from PHP code. "VM ¡÷øN" <seojuyung@hotmail.com> wrote in message news:F152pgTFur2iz2Mb1s700003145@hotmail.com...

Hello I want to know how to implement these several sql statements in one time. For example, I have 2 sql statements like :

INSERT INTO com VALUES ('pentium');

INSERT INTO com VALUES ('amd'); Then, I want to excute these 2 sql statements in one time with PHP. I tried to implement like this : $query = " INSERT INTO com VALUES ('pentium'); INSERT INTO com VALUES ('amd'); "; mysql_query($query, $dbconnect); But as you know, it didn't work.

Does any one know how to run this job?

-- +------------------------ Open source questions? ------------------------+ | Steve Edberg University of California, Davis | | sbedberg@ucdavis.edu Computer Consultant | | http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ | +----------- http://pgfsun.ucdavis.edu/open-source-tools.html -----------+