Hi,
I have a table as below.
id name parentid
1 a 0
2 b 0
3 c 1
4 d 1
5 e 3
6 f 3
7 g 6
Now, if i delete id 1, it should delete all the child nodes { 3, 4, 5, 6, 7} in the same table and same structure. This is not limited, it should do upto n child of child. Please specify me code snippets or references.
Thanks
Go to the complete details ...