mysql treeview php (count records from related tables)

Končano Objavljeno pred 5 letoma/leti Plačilo ob prevzemu
Končano Plačilo ob prevzemu

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 Arhitektura porgramske opreme

ID projekta: #18568859

Več o projektu

6 predlogov Oddaljen projekt Aktiven pred 5 letoma/leti

Dodeljeno:

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 v 3 dneh
(128 mnenj)
6.2

6 freelancerjev ponuja v povprečju za $23 na tem delu

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 v 1 dnevu
(182 ocen)
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 Več

$25 USD v 3 dneh
(57 ocen)
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 Več

$20 USD v 1 dnevu
(8 ocen)
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 Več

$25 USD v 1 dnevu
(12 ocen)
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 v 1 dnevu
(0 ocen)
0.0