[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
