Fetching related tables

[eluser]InsiteFX[/eluser]
Here is my code, may work for you

Code:

// --------------------------------------------------------------------

    /**
     * get_all_posts_by_category
     *
     * Description:
     *
     * @access    public
         * @param       string - $category_id
     * @return    array
     */
    public function get_all_posts_by_category($category_id)
    {
        $data = array();

        $this->db->where("category_id", $category_id);
        $this->db->where('status', 'published');

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

        if ($query->num_rows() > 0)
        {
            foreach ($query->result_array() as $row)
            {
                $data[] = $row;
            }
        }

        $query->free_result();

        return $data;
    }

InsitefX