Re: [PHP-DB] Maintain MySQL Transactions

[Jeroen Timmers]

what would you like todo?
explain further

Jeroen
- Original Message - 
From: Hayan Al Mamoun [EMAIL PROTECTED]
To: PHPList (E-mail) [EMAIL PROTECTED]
Sent: Saturday, February 09, 2002 7:51 AM
Subject: [PHP-DB] Maintain MySQL Transactions


 Hi, How can I maintain MySQL transactions with PHP
 
 Best Regards
 Hayan
 
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 
 


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Maintain MySQL Transactions

[Miles Thompson]

Unless there has been a very recent development, MySQL doesn't support 
transactions. Use PostgreSQL, DB, etc.

Miles Thompson


At 09:51 AM 2/9/2002 +0300, Hayan Al Mamoun wrote:
Hi, How can I maintain MySQL transactions with PHP

Best Regards
Hayan


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Re: [PHP-DB] Maintain MySQL Transactions

[Jeroen Timmers]

you must first connect to the mysql database,

for example

  $dbhost = localhost;
  $dbuser = DATABASE USER;
  $dbpass = DATABASE PASSWORD;
  $database = DATABASE NAME;
  @mysql_connect($dbhost, $dbuser, $dbpass) or die (Deze pagina is
tijdelijk offline.);
  @mysql_select_db($database) or die (Deze pagina is tijdelijk offline.);

after the connect you need to query the stuff

for example

$result = mysql_query(select * from table where id  5);
while ($row = mysql_fetch_array($result))
{
  echo $rij[0];
  echo $rij[id];
}

/* delete query */'
$result = mysql_query(delete from table where id = 1);
$nr = mysql_affected_rows($result);

echo $nr . rows are deleted.;

i hope you have enough info

the examples are not tested.

Jeroen Timmers.

http://www.php.net/manual/en/ref.mysql.php
- Original Message -
From: Hayan Al Mamoun [EMAIL PROTECTED]
To: Jeroen Timmers [EMAIL PROTECTED]
Sent: Saturday, February 09, 2002 12:54 PM
Subject: Re: Re: [PHP-DB] Maintain MySQL Transactions


 I have two sql statements, and I want to execute them all or
 nothing at all.
 For an example
 1- Delete * from sometable where Id=SOMETHING
 2- insert into OtherTable (fieldlist) values (valuelist) where
 Id=SOMETHING.
 How can I do so?




 
 Get your own 800 number
 Voicemail, fax, email, and a lot more
 http://www.ureach.com/reg/tag


  On Sat, 9 Feb 2002, Jeroen Timmers ([EMAIL PROTECTED])
 wrote:

  what would you like todo?
  explain further
 
  Jeroen
  - Original Message -
  From: Hayan Al Mamoun [EMAIL PROTECTED]
  To: PHPList (E-mail) [EMAIL PROTECTED]
  Sent: Saturday, February 09, 2002 7:51 AM
  Subject: [PHP-DB] Maintain MySQL Transactions
 
 
   Hi, How can I maintain MySQL transactions with PHP
  
   Best Regards
   Hayan
  
  
   --
   PHP Database Mailing List (http://www.php.net/)
   To unsubscribe, visit: http://www.php.net/unsub.php
  
  
 
 
 





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Maintain MySQL Transactions

[Jason Wong]

On Sunday 10 February 2002 00:21, Miles Thompson wrote:
 Unless there has been a very recent development, MySQL doesn't support
 transactions. Use PostgreSQL, DB, etc.

The v4 series of MySQL does support transactions.


-- 
Jason Wong - Gremlins Associates - www.gremlins.com.hk

/*
Without love intelligence is dangerous;
without intelligence love is not enough.
-- Ashley Montagu
*/

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Maintain MySQL Transactions

[Paul DuBois]

At 2:00 +0800 2/10/02, Jason Wong wrote:
On Sunday 10 February 2002 00:21, Miles Thompson wrote:
  Unless there has been a very recent development, MySQL doesn't support
  transactions. Use PostgreSQL, DB, etc.

The v4 series of MySQL does support transactions.

MySQL has supported transactions since version 3.23.17.  At that time
BDB tables were the only transaction-capable type.  InnoDB tables were
added in version 3.23.34a.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Maintain MySQL Transactions

[Hayan Al Mamoun]

Hi, How can I maintain MySQL transactions with PHP

Best Regards
Hayan


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php