You cant do this.
Its even recommended to drop the `;' from the end of the sql command.
You can go around using array to store the sql statements and use foreach to
run mysql_query with thee sql statement.
But I don't think its right way to do thing !
If you intention was to do update one after other then you should use locks
or use Postgres :)
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
http://sites.canaan.co.il
--------------------------
----- Original Message -----
From: "lallous" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 14, 2001 12:59 PM
Subject: [PHP] PHP: mysql_query()
> Actually the mysql_query() seems to accept only one statement at a time.
>
> Any work around so i can do query suchs:
>
> mysql_query("
> SELECT 1+1;
> SHOW DATABASES;
> USE database1;
> SELECT * FROM table1;
> ");
>
> Just multiple commands seperated with ';' ? (as if using the Mysql command
> prompt)
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]