count all left and right node

Question

ikrami.hall 0 Newbie Poster

11 Years Ago

count all left and right nodes

mysql

2 Contributors
4 Replies
68 Views
2 Days Discussion Span
Latest Post 11 Years Ago Latest Post by ikrami.hall

pritaeas 2,194 ¯\_(ツ)_/¯

11 Years Ago

What do you have so far?

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

ikrami.hall 0 Newbie Poster · Answer 1 · 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 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster · Answer 2 · 2012-12-03T11:42:11+00:00

pritaeas 2,194 ¯\_(ツ)_/¯

11 Years Ago

What is the output you are expecting?

ikrami.hall 0 Newbie Poster · Answer 3 · 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 )