Hello
MySQL isn't a transactional DB it doesn't know rollback and commit.
You can solve the problem probably by locking the tables (LOCK / UNLOCK)
Regards
Koen
On 07/11/05, Bastien Koert [EMAIL PROTECTED] wrote:
I don't think you can. Once the script finishes the connections are closed
and
At 09:37 08/11/2005, you wrote:
Message-ID: [EMAIL PROTECTED]
Date: Mon, 07 Nov 2005 11:47:32 +
From: Adrian Bruce [EMAIL PROTECTED]
MIME-Version: 1.0
To: php-db@lists.php.net
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Subject: Specific order
On Tuesday 08 November 2005 09:37, Koen Wagemans wrote:
MySQL isn't a transactional DB it doesn't know rollback and commit.
MySQL does support transactions so long as you use a reasonably recent version
and InnoDB tables.
However as Bastien suggested a transaction can't persist beyond the
Incorrect, MySQLs MyISAM engine is non transactional, the InnoDB engine /
BDB egines both support transactions
Bastien
From: Koen Wagemans [EMAIL PROTECTED]
To: Bastien Koert [EMAIL PROTECTED]
CC: [EMAIL PROTECTED], php-db@lists.php.net
Subject: Re: [PHP-DB] transactions
Date: Tue, 8 Nov
What is the recommended way to find the number of rows found by a SELECT
query? PDOStatement::rowCount() doesn't work with MySQL and is a bit
of a hack anyway. Doing a COUNT(*) before the SELECT is very hackish -
the data could have changed and it's an extra query. What is there
that's better
mysql_num_rows()
On Tuesday 08 November 2005 5:17 am, Rob C wrote:
What is the recommended way to find the number of rows found by a SELECT
query? PDOStatement::rowCount() doesn't work with MySQL and is a bit
of a hack anyway. Doing a COUNT(*) before the SELECT is very hackish -
the data
I suppose you could use count( PDOStatement::fetchAll() ), but I
understand your amazement.
mysql_num_rows() is specific to MySQL. He wants a PDO version.
-Original Message-
From: Micah Stevens [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 08, 2005 10:51 AM
To: php-db@lists.php.net
yeah, it would help if I read the whole post. Sorry.
On Tuesday 08 November 2005 9:06 am, Dwight Altman wrote:
I suppose you could use count( PDOStatement::fetchAll() ), but I
understand your amazement.
mysql_num_rows() is specific to MySQL. He wants a PDO version.
-Original
There's a function called 'found_rows()' function, so you could try issuing a
query, then issuing a second one 'SELECT FOUND_ROWS();' and it should give
the number of rows returned by the previous select.
Here's details:
http://dev.mysql.com/doc/refman/4.1/en/information-functions.html
On
Julien Bonastre a écrit :
and relation to Ronald Rivest??
As in the Ronald Rivest, Leonard Adleman, Adi Shamir? RSA Encryption
Rivest?
Just curious :-)
No! :)
--
Alain -- http://www.vivahate.org
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
10 matches
Mail list logo