count all left and right node

Question

0

count all left and right nodes

Attachments

mysql

pritaeas 1,895 · Answer 1 · 2012-12-02T10:53:33+00:00

What do you have so far?

ikrami.hall · Answer 2 · 2012-12-02T11:19:48+00:00

i have count for first level of child , but i need all child count for the parent

pritaeas 1,895 · Answer 3 · 2012-12-03T11:42:11+00:00

What is the output you are expecting?

ikrami.hall · Answer 4 · 2012-12-03T22:03:45+00:00

every ID with all childs for example
(Parent) ikrami
(Left) karim
(Right) hady

so i need to get for ikrami in left column ( Karim and all childs left or right from karim ) and in column right ( hady and all childs left or right from hady )