Mysql Query Issue [Solved]

Mysql Query Issue [Solved]

El Forum
Unregistered

01-13-2009, 03:39 AM

[eluser]ywftdg[/eluser]
Error Number: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right
syntax to use near '(CURDATE() - INTERVAL 1 QUARTER)

I am running Mysql 5.0.41 and other basic Quarter stuff works fine.

Code:
if ($datepost == '2') {        // Last Quarter BUG

            $this->db->where('QUARTER(rTimeStamp) = QUARTER (CURDATE() - INTERVAL 1 QUARTER)');

        }

Messages In This Thread

Mysql Query Issue [Solved] - by El Forum - 01-13-2009, 02:48 AM

Mysql Query Issue [Solved] - by El Forum - 01-13-2009, 03:06 AM

Mysql Query Issue [Solved] - by El Forum - 01-13-2009, 03:13 AM

Mysql Query Issue [Solved] - by El Forum - 01-13-2009, 03:19 AM

Mysql Query Issue [Solved] - by El Forum - 01-13-2009, 03:24 AM

Mysql Query Issue [Solved] - by El Forum - 01-13-2009, 03:33 AM

Mysql Query Issue [Solved] - by El Forum - 01-13-2009, 03:39 AM

Mysql Query Issue [Solved] - by El Forum - 01-13-2009, 03:48 AM

Mysql Query Issue [Solved] - by El Forum - 01-13-2009, 04:06 AM

Mysql Query Issue [Solved] - by El Forum - 01-13-2009, 04:35 AM