Re: [PHP-DB] transactions

2005-11-08 Thread Koen Wagemans
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

[PHP-DB] Re: Subject: Specific order by MySQL statement

2005-11-08 Thread Neil Smith [MVP, Digital media]
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

Re: [PHP-DB] transactions

2005-11-08 Thread Simon Rees
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

Re: [PHP-DB] transactions

2005-11-08 Thread Bastien Koert
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

[PHP-DB] [PDO] Number of rows found by Select

2005-11-08 Thread Rob C
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

Re: [PHP-DB] [PDO] Number of rows found by Select

2005-11-08 Thread Micah Stevens
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

RE: [PHP-DB] [PDO] Number of rows found by Select

2005-11-08 Thread Dwight Altman
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

Re: [PHP-DB] [PDO] Number of rows found by Select

2005-11-08 Thread Micah Stevens
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

Re: [PHP-DB] [PDO] Number of rows found by Select

2005-11-08 Thread Micah Stevens
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

Re: [PHP-DB] odbc vs. oci8

2005-11-08 Thread Alain Rivest
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: