> [snip]
> SELECT DISTINCT `TIER3DATA` AS id, `TIER2DATA` AS parentId FROM `POSITION_SETUP` WHERE `COMPANY_ID` = '3' AND `TIER2DATA` IN ('Executives and Management','Professionals','Technicians','Craft Workers-Skilled','Operatives','Contractor','Sales Workers','Laborers and Helpers','Admin Support')
>
> and it is empty.
[/snip]
I figured out part of the problem - the for loop starts at tier2 instead of tier1
Once I made that change I get the following error:
Fatal error: Cannot use string offset as an array in /home/orcadept/public_html/poschart/json_chart.php on line 139
Line 139 is $item['children'][$id] = &$child;
