the problem is DATEDIFF command available in MySQL ver 4.1.1 above
In MySQL versions 4.1.1 you can use the following construct:
SELECT TO_DAYS('2006-10-06') - TO_DAYS('2006-10-05')
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Chris skrev:
It doesn't explicitly say anything about when a connection is lost but
I'm guessing it would rollback the transaction (well I'd sure hope so).
Me too. In any case, I'm now also using register_shutdown_function,
which calls a function that does rollback of not committed
I hope never!!
Specially with disruptive technologies!!
Miguel Guirao
-Original Message-
From: Jeremy Peterson [mailto:[EMAIL PROTECTED]
Sent: Martes, 10 de Octubre de 2006 06:29 a.m.
To: php-db@lists.php.net
Subject: [PHP-DB] Google Code Search
Another resource for source code,
Reason I'm asking is, I've seen some deadlock issues in a script (using
FOR UPDATE and LOCK IN SHARE MODE), that looks like they are caused by
transactions not being rolled back (releasing locks) correctly.
Do you use pconnect? If I right remember there was a bug in some version
of mysql that