[Resolved] Tough Loop

DuNuNuBatman

Hey all, here is the deal. I need to make a loop/nested loop that will display links in the form of a directory tree. For example:

RootDirectory
- SubUnder Root
- - Sub Under Sub
- - - Yet Another Sub
- - Another Sub Under Sub
Another Root
- Sub
- - Sub Sub
- - Sub Sub2
- - - Sub Sub Sub

Anyway, something like that. I have a list of links each has the id of the parrent dir. My goal is to loop through the links and display them in the format of a directory tree. I'll be online all day if you would like to help. If you would like to email me directly my email address is jdale@pcfloans.com and thank you for the help.

mtimdog

What does your database look like, and what is the main-directory's id (probly 0 or 1 if I had to guess).

Recursive function (allowing 4 levels)

call with id of top level like

levels(0, 1);

pseudo

function levels($id, $level){
$sql_query="setup query here where id='$id'";
$query_result=mysql_query($sql_query);
while($levs = mysql_fetch_array($query_result)){
    for ($i = 0;$i<$level;$i++)  echo '-';

   echo $levs['name'];
   if ($level < 4) levels($levs['id'], $level + 1);

}




}

Well, something like that should work. maybe:p

DuNuNuBatman

ah, levels, you just gave me a couple really good ideas.
What my database looks like is I have 1 table, Groups, and I have a couple columns in it for instance GroupID, GroupParentID

Group ID being the autonumber value of that group.
Group Parent ID being the GroupID of the parent group.

For Example:
(GroupID)(Name)(GroupParentID)
1 root 0
- 2 sub 1
- - 3 sub 2
- 4 sub 1

That'll kinda give you the idea.
The problem is I want to loop through the groups and loop through the subs. That is where I am running into trouble.

I can't figure out a way to loop through my groups and display sub groups and their sub groups and their sub groups etc...

DuNuNuBatman

Thanks alot mtimdog your script worked perfect, it was exactly what I was looking for. I didn't realize you could call a function within the same function. Thanks Alot!!!