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

2001-09-20 Thread _lallous
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

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

2001-09-20 Thread mydata
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

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

2001-09-20 Thread James Holloway
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

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

2001-09-20 Thread Steve Edberg
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,