¡@
php Programming Glossary: televisionsGet all child, grandchild etc nodes under parent using php with mysql query results http://stackoverflow.com/questions/11497202/get-all-child-grandchild-etc-nodes-under-parent-using-php-with-mysql-query-resu appears like this id name parent_id 1 Electronics 0 2 Televisions 1 3 Portable Electronics 1 4 Tube 2 5 LCD 2 6 Plasma 2 7 Mp3.. id 1 name Electronics parent_id 0 1 Array id 2 name Televisions parent_id 1 2 Array id 3 name Portable Electronics parent_id.. parent_id 0 children Array 2 Array id 2 name Televisions parent_id 1 children Array 4 Array id 4 name Tube parent_id..
mySQL query for selecting children http://stackoverflow.com/questions/609328/mysql-query-for-selecting-children 1 NULL MyStore 2 1 Electronics 3 1 Clothing 4 1 Books 5 2 Televisions 6 2 Stereos 7 5 Plasma 8 5 LCD t_categories after modification.. NULL NULL 3 1 Clothing NULL NULL 4 1 Books NULL NULL 5 2 Televisions NULL NULL 6 2 Stereos NULL NULL 7 5 Plasma NULL NULL 8 5 LCD.. 0 2 1 Electronics 1 1 3 1 Clothing 1 1 4 1 Books 1 1 5 2 Televisions 2 1 2 6 2 Stereos 2 1 2 7 5 LCD 3 1 2 5 8 7 Samsung 4 1 2 5..
|
