[solved] using active records WHERE with now()

[eluser]bretticus[/eluser]
try printing the compiled query out to your browser:

Code:

function get_funerals()
    {
        $this->db->where('visitation >', 'NOW()');
        $query = $this->db->get('funerals');
        echo $this->db->last_query();
        return $query->result();
    }

or turn on profiling to get a look:

Code:

function get_funerals()
    {
        $this->output->enable_profiler(TRUE);
        $this->db->where('visitation >', 'NOW()');
        $query = $this->db->get('funerals');
        return $query->result();
    }

Oh by the way, when you return $query->result() you are just returning one row.