> [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;
