Welcome Guest, Not a member yet? Register   Sign In
Mysql Query Issue [Solved]
#10

[eluser]ywftdg[/eluser]
Solved:

Code:
if ($datepost == '2') {        // Last Quarter
            
            $this->db->where('QUARTER(rTimeStamp) = QUARTER(DATE_ADD(CURDATE(), INTERVAL -3 MONTH))');
            
            if ( $this->querydate == '01' || $this->querydate == '02' || $this->querydate == '03' ) {    
                $this->db->where('YEAR(rTimeStamp) = YEAR(CURDATE())-1');
            } else {
                $this->db->where('YEAR(rTimeStamp) = YEAR(CURDATE())');
            }
                
        }


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



Theme © iAndrew 2016 - Forum software by © MyBB