Hello Everyone
1) I need to store in My SQL database a hierarchical categories structure that allows
for unlimited 10 level depth.
The example table structure
Categories
----------
ID (INT)
ParentID (INT)
Name (VARCHAR(255))
We are write the query the hierarchy but some sql error, please guide me how the write hierarchy level query in PHP - mysql
if any one example guide me.
Thanks
Hierarchical categories structure my-sql and PHP
Moderator: General Moderators
Re: Hierarchical categories structure my-sql and PHP
Take a look at
http://dev.mysql.com/tech-resources/art ... -data.html
http://dev.mysql.com/tech-resources/art ... -data.html
There are 10 types of people in this world, those who understand binary and those who don't