Re: Create view with MySQL 4.1.20

[tanja]

Hi Nick,

the depth 3 is the dependencies between parent_id and child_id.
it's a tree...
So

ch_id p_id
1 0
2 0
3 1
4 3


Then my depth is 0->1->3->4
And I want know the number of this depth to make the loop for step in my program... this depth is different. I should count for different parent_id's the depth...
e.g.
p_id = 1;
my depth is 1->3->4 ... now 2

May be exits another possibility?

Thank
Regards Tanja