If you use Categories {id, parent_id, name, description} (note
parent_id) to identify the parent of the current node you can use
Model::findAllThreaded() which will automatically build the array in a
nested fashion.
On Jun 9, 7:06 am, Juan Pablo Araya <[EMAIL PROTECTED]> wrote:
> Do a <? pr($categories); ?> in app/views/categories/index.thtml (cake
> 1.1) so you can see the nested array.
>
> IMHO sub category is a model of kind "category":
>
> Categories {id, cat_id, name, description}. If the category is a root-
> category, then cat_id can be 0 or another value. Thus you have a
> recursive model (the same idea behing the threaded posts in a forum. I
> used this kind of trick in some php non-cake applications, anybody
> knows is there are any problem with this kind of model in cake?
>
> Saludos and sorry for my poor english
>
> On 8 jun, 10:54, in-sanity <[EMAIL PROTECTED]> wrote:
>
> > Hi all!
>
> > I've been trying for a while now to build a menu that looks like this:
>
> > Category 1
> > subcat1, subcat2, subcat3...
>
> > Category 2
> > subcat2.1, subcat2.2, subcat3.3...
>
> > and so on...
>
> > I can't seem to get around the nested array returned by the
> > controller ...
> > categories controller code:
>
> > class CategoriesController extends AppController {
>
> > var $name = 'Categories';
>
> > function index(){
> > $this->set('categories', $this->Category->findAll());
> > }
>
> > }
>
> > the category model looks like this:
> > class Category extends AppModel {
>
> > var $name = 'Category';
> > var $hasMany = array('Subcategory' =>
> > array('className' => 'Subcategory',
> > 'conditions' => '',
> > 'order' => '`Subcategory`.`id`
> > ASC',
> > 'dependent' => true,
> > 'foreignKey' =>
> > '`cat_id`'
> > ),
> > 'Article' =>
> > array('className' => 'Article',
> > 'conditions' => '',
> > 'order' => '`Article`.`created`
> > DESC',
> > 'limit' => '3',
> > 'dependent' => true,
> > 'foreignKey' =>
> > '`cat_id`'
> > )
> > );
>
> > }
>
> > and the tables form the database look like this:
>
> > CREATE TABLE `categories` (
> > `id` int(11) NOT NULL auto_increment,
> > `name` varchar(50) collate latin1_general_ci NOT NULL,
> > `description` varchar(255) collate latin1_general_ci NOT NULL,
> > PRIMARY KEY (`id`)
> > ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci
> > AUTO_INCREMENT=2 ;
>
> > CREATE TABLE `subcategories` (
> > `id` int(11) NOT NULL auto_increment,
> > `cat_id` int(11) NOT NULL,
> > `name` varchar(50) collate latin1_general_ci NOT NULL,
> > `description` varchar(255) collate latin1_general_ci NOT NULL,
> > PRIMARY KEY (`id`)
> > ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci
> > AUTO_INCREMENT=3 ;
>
> > Help me!
>
> > Thanks in advance for your ideas and guidance.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
