mysql treeview php (count records from related tables)

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.


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)

Skills: AJAX, Javascript, MySQL, PHP, Software Architecture

See more: php count days mysql, count mysql complex php, joomla count records using mysql, php mysql hierarchical data, mysql 5.6 recursive query, mysql recursive query all child, mlm treeview in php source code, mysql recursive query parent child tree, mysql get all child nodes for parent, tree structure in php with mysql example, mysql tree structure query, mysql delete similar records different tables, php count file downloads store mysql, count records using nusoap php, display records mysql table php source code, sample treeview php mysql, vb6 count records mysql, cloning tables mysql con php, mysql perl count records, joomla mysql count records

About the Employer:
( 1 review ) Victoria, Mexico

Project ID: #18568859

Awarded to:


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

$30 USD in 3 days
(106 Reviews)

8 freelancers are bidding on average $24 for this job


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 in 1 day
(161 Reviews)

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 More

$25 USD in 3 days
(40 Reviews)

Hello Employer, Greetings for the day! ⭐⭐⭐⭐⭐ I CAN START IMMEDIATELY ⭐⭐⭐⭐⭐ My name is Dmitry Kraitor and I am full-stack&full-time web developer. I have gone through the project description and I am very int More

$30 USD in 1 day
(18 Reviews)

Hi. As a programmer with academic background, I can certainly help you with this. Just drop me a message.

$25 USD in 0 days
(20 Reviews)

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 More

$25 USD in 1 day
(10 Reviews)

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 More

$20 USD in 1 day
(5 Reviews)

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

$15 USD in 1 day
(0 Reviews)