Re: Thinking out loud - a continuation...

On 12-03-23 03:52 PM, Jay Blanchard wrote:

[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

It's meant to since outside the loop we address tier 1 when we generate the root and first set of parents (These have no parent ID so they are a special case).

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;

$item['children'] should be an array, somehow a string has been assigned :/ Cheers, Rob. -- E-Mail Disclaimer: Information contained in this message and any attached documents is considered confidential and legally protected. This message is intended solely for the addressee(s). Disclosure, copying, and distribution are prohibited unless authorized.