I
want to know about 'multilevel category' in mysql database
.Please let me knnow about it.
mysql database related quetion
Moderator: General Moderators
-
subhash_garai
- Forum Newbie
- Posts: 12
- Joined: Mon Mar 27, 2006 8:09 am
-
subhash_garai
- Forum Newbie
- Posts: 12
- Joined: Mon Mar 27, 2006 8:09 am
yes . can u help me to build such a hierarchy?For example:
1. First Main Service Category
-- a. First Sub Service Category
---- (i) First Sub Category
------ 1. First Description
------ 2. Second Description
---- (ii) Second Sub Category
------ 1. First Description
-- b. Second Sub Service Category
---- (i) First Description
---- (ii) Second Description
2. Second Main Service Category
-- a. First Sub Service Category
---- (i) First Description
-- b. Second Sub Service Category
---- (i) First Description
1. First Main Service Category
-- a. First Sub Service Category
---- (i) First Sub Category
------ 1. First Description
------ 2. Second Description
---- (ii) Second Sub Category
------ 1. First Description
-- b. Second Sub Service Category
---- (i) First Description
---- (ii) Second Description
2. Second Main Service Category
-- a. First Sub Service Category
---- (i) First Description
-- b. Second Sub Service Category
---- (i) First Description
-
subhash_garai
- Forum Newbie
- Posts: 12
- Joined: Mon Mar 27, 2006 8:09 am
You can design your database just about anyway you want and display it just about any way you want with php. Why don't you go try something out and post it in the database section?subhash_garai wrote:multilevel category in the sense that there are contents which i will have to show in a heirarchical structure. The thing is that i am using database mysql. So i want to know the databasestructure to be built on mysql and the php code to show them on that structure .please help me out.
1. Paper
-- a. Recycled
---- (i) Size
------ 1. A4
------ 2. A3
---- (ii) Color
------ 1. Red
------ 1. etc..
-- b. Non-recycled
---- (i) Size
---- (ii) Color
2. Glass
-- a. Recycled
---- (i) etc..
-- b. Non-recycled
---- (i) etc...
-
subhash_garai
- Forum Newbie
- Posts: 12
- Joined: Mon Mar 27, 2006 8:09 am
I do it using the methods described in this tutorial!
either The Adjacency List Model or the Modified Preorder Tree Traversal
http://www.sitepoint.com/article/hierar ... a-database
either The Adjacency List Model or the Modified Preorder Tree Traversal
http://www.sitepoint.com/article/hierar ... a-database