Categories and Sub Categories

[eluser]bluepicaso[/eluser]
thnx morcegon...
your post helped
here is my code for model
get.php

Code:

function getParentCats()

    {

        $this->db->select('*');

        $this->db->from('category');

        $this->db->where('parent_cat', 0);

        

        $query = $this->db->get()->result_array();

        foreach($query as $row)

        {

            $data[] = $row;

        }

        return $data;

        $this->db->close();

    }



    function getSubCats($parentid)

    {

        $this->db->select('*');

        $this->db->from('category');

        $this->db->where('parent_cat', $parentid);

        $query = $this->db->get()->result_array();

        foreach($query as $row)

        {

            $data[] = $row;

        }

        return $data;

        $this->db->close();

    }

code for my controller

Code:

function whatever()

    {

        $this->load->model('get');

        $dbCategories = $this->get->getParentCats();

        foreach ($dbCategories as $dbCategory)

        {

            

            $categories[$dbCategory['cat_name']]['subcategories'] = @$this->get->getSubCats($dbCategory['cat_id']);

        }

        ?>

        <pre>

        &lt;?

        print_r($categories);

        ?&gt;

        </pre>

        &lt;?

    }

My purpose solves here. I want to delete all packages and sub categories