+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Generating Associative Hierarchy array for unlimited cateogries (/showthread.php?tid=46913)
Generating Associative Hierarchy array for unlimited cateogries - El Forum - 11-20-2011
[eluser]Unknown[/eluser]
I have a category database setup like this
Code:
CREATE TABLE `categories` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`parent_id` INT( 11 ) NOT NULL ,
`name` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( `id` )
);Data is as follows:
Code:
-------------------------------------
| id | name | parent_id |
-------------------------------------
| 1 | Electronics | 0 |
| 2 | ReadyMades | 0 |
| 3 | TV | 1 |
| 4 | Mobile Phones | 1 |
-------------------------------------I would like to generate an associative array in this format
Array (
[0] =>
Array ( [id] => 1,[name]=> Electronics, [children] => Array (
[0] => Array ( [id] => 3,[name]=> TV, [children] => Array() )
[1] => Array ( [id] => 4,[name]=> Mobile Phones, [children] => Array() )
)
)
[1] => Array ( [id] => 2,[name]=> ReadyMades, [children] => Array() )
)
Please help me