[PHP] About MySQl and Transactions

2001-05-09 Thread Hassan Arteaga

Hi all !!!

I'd like to implement this pseudocode

1-open connection with MySQL
2-beintransaction
3-add data to table1
4-add data to table2  
5-commit transacction   or die (rollbacktransacciont)

How I implements transaccions in MySQL


Thanks all !!!

--
M. Sc. Hassan Arteaga Rodríguez
Microsoft Certified System Engineer
Network Admin, WEB Programmer
FUNDYCS, Ltd
[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]




Re: [PHP] About MySQl and Transactions

2001-05-09 Thread Fredrik Rodland

I don't think MySql does not have support for transactions.  Try using
another DB - like postgres.

Fredrik


On Wed, 9 May 2001, Hassan Arteaga wrote:

 Hi all !!!

 I'd like to implement this pseudocode

 1-open connection with MySQL
 2-beintransaction
 3-add data to table1
 4-add data to table2
 5-commit transacction   or die (rollbacktransacciont)

 How I implements transaccions in MySQL


 Thanks all !!!

 --
 M. Sc. Hassan Arteaga Rodríguez
 Microsoft Certified System Engineer
 Network Admin, WEB Programmer
 FUNDYCS, Ltd
 [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]


F


--
Fredrik Rødland   ASTON Technology  Phone: +47 23 28 40 17
Technical Architect   Stocknet  Fax  : +47 910 73 621
[EMAIL PROTECTED]  http://www.aston.no   Mob  : +47 992 19 817


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




Re: [PHP] About MySQl and Transactions

2001-05-09 Thread Christian Dechery

At 20:09 9/5/2001 +0200, Fredrik Rodland wrote:
I don't think MySql does not have support for transactions.  Try using
another DB - like postgres.

yes it does... download Mysql-Max or install BDB in your mysql dist (if you 
are under *ux or *ix)...

Mysql-Max is the newest Mysql dist including BDB (which support transactions)...


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