If I understand your data model correctly, the nested array returned by
Category::findAll() would look something like this (I think):
Array (
[0] => Array (
[Category] => Array (
[id] => 1,
[name] => 'Category Name',
[description] => 'Category Description'
),
[Subcategory] => Array (
[0] => Array (
[id] => 1
[cat_id] => 1
[name] => 'Subcategory Name'
[description] => 'Subcategory Description'
),
[1] => ...
...
),
[Article] => Array (
[0] => Array (
whatever fields....
),
...
)
)
[1] => Array ( ... )
...
)
Is that what you were looking for?
in-sanity 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.
>
>
> >
>
--
Joshua Benner
http://bennerweb.com
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
