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
Another resource for source code, when will Google stop being so
innovative... :)
http://www.google.com/codesearch
Jeremy
Jeremy Peterson, MACS
Automation Systems Administrator
Education Technology Services
Moody Bible Institute
820 N. LaSalle Drive
Chicago, IL, 60610
Email: [EMAI
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 transations
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, when
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 in
I expected something better from Google. The Code Search function is not
that good.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php