Set Posts activ/inactiv

[eluser]Zimooon[/eluser]
Hey

I call this function: getactivePosts() :

Code:

}      

  function getactivePosts($active = FALSE) {
    if($active == TRUE)
    {
     $this->db->where('active',1);
    }
    $query = $this->db->get('posts');
    $posts = array();

    foreach ($query->result() as $row) {
        $posts[] = array(
            'id' => $row->id,
            'title' => $row->title,
            'content' => $row->content,
            'date' => $row->date,
            'active' => $row->active
            
            
        );
    }

    return $posts;
}

In my database active is :

typ: tinyint
length/set : 1
standard: NULL
attribute: unsigned
Null: "checked"