mysql treeview php (count records from related tables)

Completado Publicado hace 5 años Pagado a la entrega
Completado Pagado a la entrega

I have 3 TABLES (tbl_a, tbl_b, tbl_c)

tbl_a is the treeview , tbl_b has related fields to tbl_a, and tbl_c which has the record to be counted:

We are good so far, I got this working, the issue is to show counted record to each parent id in treeview.

Example:

ROOT (189)

- subroot1 (132)

-- sub sub1 root (72)

-- sub sub1 root2 (55)

-- sub sub1 root3 (5)

-subroot2 (45)

-- sub sub2 root (20)

-- sub sub2root2 (15)

-- sub sub2 root3 (10)

-subroot3 (12)

AJAX JavaScript MySQL PHP Arquitectura de software

Nº del proyecto: #18568859

Sobre el proyecto

6 propuestas Proyecto remoto Activo hace 5 años

Adjudicado a:

softcarve

Hi, I would like to show the counts from the above tables. Available for discussion and ready to start now. Regards, Manish

$30 USD en 3 días
(128 comentarios)
6.2

6 freelancers están ofertando un promedio de $23 por este trabajo

abugosia

Hello, I'm Abu Gosia. I'm interesting your project very well. I m quite well experienced in these jobs. Let's go ahead with me. Thanks

$25 USD en 1 día
(182 comentarios)
6.9
ludwig333

Hi. I have read your description and have interests in your project. I have some experience in projects similar to yours. I am ready for your project now. I would like to have a discussion on chat to get more about Más

$25 USD en 3 días
(57 comentarios)
6.2
theguyyfrooks

Hi, Good day to you. Hope that you are fine and enjoying good health. I’ve read your requirements and understood it completely. I’m a senior web developer and i am very confident to take over this project. I guarantee Más

$20 USD en 1 día
(8 comentarios)
4.0
Lifu0415

Hello. How are you? Thanks for your good description of project and I understood what you need. As an web expert. i have strong skills and experiences in web development for 7 years. I haven't been worked in freel Más

$25 USD en 1 día
(12 comentarios)
4.5
gagsrags

Certified DBA, Will give you optimized Query for this case. Will suggest Indexes you need to create to future optimized this query.

$15 USD en 1 día
(0 comentarios)
0.0