Active record WHERE clause not working?

[eluser]InsiteFX[/eluser]
This is how I use where in my blog model and it works for me, not sure if it will help you.

Also if using CI 2.0 make sure you download the latest version from the Reactor.

Code:

function get_post($id)
{
    $data = array();

    $this->db->where('id', $id);
    $this->db->limit(1);

    $query = $this->db->get('posts');

    if ($query->num_rows() > 0)
    {
        $data = $query->row_array();
    }

    $query->free_result();
    return $data;
}

InsiteFX