[solved] using active records WHERE with now()

[eluser]Pale Rider[/eluser]
hmmm well i did

Code:

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

and it gave me

Code:

SELECT * FROM (`funerals`) WHERE `visitation` > 'NOW()'

o_O


result just returns one result? What should I be using? I have many queries such as

Code:

function get_orders_stage1()
    {
        $this->db->select('ID, order_number, time_sales, order_stage, customer_name, timeframe, time_sensitive');
        $query = $this->db->get_where('orders', array('order_stage' => '1') );
        return $query->result();
    }

.. and they seem to be returning all the right rows.