retrive child and sub child from table
MySQL
1
Posts
1
Posters
3
Views
1
Watching
-
i have table formated as three column: id,parent_id,name ex.. id /parent_id /name 1 /null /ABC1 2 /1 /ABC2 3 /1 /ABC3 4 /2 /ABC4 5 /4 /ABC5 6 /3 /ABC6 for example i wnt to retrive perticulars child and sub child of id 2 then it should give result: 2 /1 /ABC2 4 /2 /ABC4 5 /4 /ABC5 Please giv me appropriate query for it... thanks in advance