mysql treeview php (count records from related tables)
$10-30 USD
Paid on delivery
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)
Project ID: #18568859
About the project
Awarded to:
Hi, I would like to show the counts from the above tables. Available for discussion and ready to start now. Regards, Manish
6 freelancers are bidding on average $23 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
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
Certified DBA, Will give you optimized Query for this case. Will suggest Indexes you need to create to future optimized this query.