Can anyone help or direct me to a tutorial how to set up nested list in mysql database

[Guest]

Hi there in know i am on a Adobe Dreamweaver site and I am not sure how to setup my tables in phpmyadmin for this task example below can anybody refer me to a tutorial somewhere on the web for this I have checked for tutorials regarding nested lists and mysql and found nothing yet.

header

• level1
  • level 1.1
  • level 1.2
  • level 1.3
• level 2
  • level 2.1
  • level 2.2
  • level 2.3
  • lelvel 2.4
• level 3
• level 4
  • level 4.1
  • level 4.2
  • level 4.3
  • level 4.4
• level 5
• level 6
• level7
  • level 7.1
  • level 7.2
  • level 7.3
• level 8

It will be static text on my webpage hope someone can help.

regards

[Ben M]

Database normalization is the key here and this may take multiple database tables to set up.  To get a better understanding of what you are trying to do I need to get some more details about what you are trying to accomplish.  Can "level 1.1" ever become "level 9" and vice versa?  Or can "level 1.1" become "level 2.5"?  Basically what I'm trying to get at is what is the relation and do you expect to be able to create some sort of interface to move these items around freely?  If the answer is yes you are looking at one database per table with keys on linking the child to its parent (eg: "level 2.1" to "level 2"; "level 2.1.1" to "level 2.1"; etc.).  If it is more simplistic then what I am making it out to be, you might be able to get away with a single table, but without knowing a little more about your intentions/expectations it's difficult to say more.

Below are a few tutorials on database normalization to try and help you with the concepts:

http://www.phlonx.com/resources/nf3/

http://databases.about.com/b/2007/02/25/database-normalization-tutorial.htm

[Guest]

Hi SnakEyez02

Ok I have checked out the sites you gave me and some more about database normalization to answer your question about ‘’ Can "level 1.1" ever become "level 9" and vice versa? ‘’

No level 1.1 will stay level 1.1 and the relation between level 1, level 1.1, and level 1.2 will always stay the same though out all the levels.

Correct me if I am wrong my understanding so far is that:

1. Header will be 1NF
2. Level1, level2,level3,level4,level5,level6,level7,level8 will be 2NF
3. Level1.1,level1.2,level1.3,level2.1,level2.2,level2.3,level2.4,level4.1,level4.2,level4.3,

        Level4.4, level7.1, level7.2, level7.3 will be 3NF.

I am assuming that is have to link 3NF to 2NF and then to 1NF, 1NF will be the parent.

I am aslo hoping the i can use the Create nested lists from recordset PHP in some way to get the data from my database using this normalization process.

Regards

[Guest]

Go to http://forums.adobe.com then click on Dreamweaver to go to the Dreamweaver forum. Once you're there click on the Dreamweaver FAQ category link to go to the Dreamweaver FAQ page. On the Dreamweaver FAQ page there's an area that says:

The Dreamweaver Cookbook contains a collection of articles describing how to perform a range of tasks - some simple, others more advanced - in Dreamweaver.

When you visit the Dreamweaver Cookbook there's a MySQL recipe category. From the 16 available MySQL recipies there is one titled:

Create nested lists from a recordset (PHP)

best,

Shocker