[PHP-DB] multiple queries in one php statement....

2001-07-19 Thread Koutsogiannopoulos Karolos

Hello everyone...

Could someone give me a tip ang tell me if i can insert more than one
queries in a mysql_query() statement??

etc $quer=mysql_query(" BEGIN WORK , QUERY 1 , QUERY 2, COMMIT",$db)

Thanks.
___
PGP KEY ID: 0xA86600E9
___




Re: [PHP-DB] multiple queries in one php statement....

2001-07-19 Thread Ryan Fischer

 Could someone give me a tip ang tell me if i can insert more than one
 queries in a mysql_query() statement??
 
 etc $quer=mysql_query(" BEGIN WORK , QUERY 1 , QUERY 2, COMMIT",$db)

No, you can't.  You've got to execute them one at a time.

-- 
 -Ryan :: ICQ - 595003 :: GigaBoard - http://www.gigaboard.net/



-- 
PHP Database 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]




Re: [PHP-DB] multiple queries in one php statement....

2001-07-19 Thread leo g. divinagracia iii

cant... since the function returns a code if the call is true or not. 
if you try multiple statements, you cant know which failed and which was
good...

Koutsogiannopoulos Karolos wrote:
 
 Hello everyone...
 
 Could someone give me a tip ang tell me if i can insert more than one
 queries in a mysql_query() statement??
 
 etc $quer=mysql_query( BEGIN WORK , QUERY 1 , QUERY 2, COMMIT,$db)
 
 Thanks.
 ___
 PGP KEY ID: 0xA86600E9
 ___

-- 
Leo G. Divinagracia III
[EMAIL PROTECTED]

-- 
PHP Database 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]