[PHP] 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()); Als

[PHP] Re: excuting several sql statements in one time

Hey, Whilst you can't perform statements like this, there are alternatives. If you only have one field in your table, you can use: "INSERT INTO com VALUES ('pentium'), ('amd')"; // Continue the comma separated values list Or, if you need to specify which fields the data is to go in: "INSERT I

[PHP] Re: excuting several sql statements in one time

yes, it will not work,because mysql does not support it(the way you try to use is 'procedure' called in MS SQL sever) , mysq developer said they will accomplish in the further . you and I have to wait for it. "VM ÁÖ¿N" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED

[PHP] Re: excuting several sql statements in one time

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