I have a folder structure in a database
This is a table for my folders
id - subfolder_id - folder name
1 - 0 - my folder root
2 - 1 - folder1
3 - 1 - folder2
4 - 2 - folder1 sub1
5 - 4 - folder1 sub1 sub2
6 - 3 - folder2 sub1
7 - 6 - folder2 sub1 sub2
This is a table for pages that are stored in the database:
page_id - folderid - page name
1 - 5 - my test page
this would place 'my test page' in:
folder1 sub1 sub2
I can with php easly get the data from mysql and print:
my folder root
- folder1
-- folder1 sub1
- folder2
-- folder2 sub1
but I need to continue to print the rest of folder1's tree like this:
- folder1
-- folder1 sub1
--- folder1 sub1 sub2
- folder2
-- folder2 sub1
--- folder2 sub1 sub2
and so on..
It is easy to do this if I manually creat a query for every subfolder, problem is that there can be an unlimited(well an unknown) number of subfolders and my fingers would get tired of coding this for a hundred subfolders, provided that i knew how many subfolders where in every folder.
I am lost......
Does anybody have any ideas.....
If you have gotten this far, thanks for reading anyway.
Ruckus
