Re: Thinking out loud - a continuation...

On 12-03-24 08:41 AM, Jay Blanchard wrote:

On Mar 23, 2012, at 11:24 PM, Robert Cummings wrote:

On 12-03-23 05:41 PM, Jay Blanchard wrote:

[-- DELETED GARBAGE --] :)

I just realized... I've been stuck in a thinking rut. I latched onto one solution that works well in some case but didn't fully examine the nuances of your own scenario. Given the way you are creating your hierarchy you will ultimately retrieve all rows. As such the following simple solution will do what you need: <?php

    $company = 1;

    $query =
        "SELECT DISTINCT "
       ."   * "
       ."FROM "
       ."   tiers "
       ."WHERE "
       ."   company = {$company} ";

    $root = array();
    if( $db->query( $query ) )
    {
        while( ($row = $db->fetchRow()) )
        {
            $focus =&$root;
            for( $i = 1; $i<= 14; $i++ )
            {
                $name = $row['tier'.$i];

                if( !isset( $focus[$name] ) )
                {
                    $focus[$name] = array();
                }

                $focus =&$focus[$name];
            }
        }
    }

    $json = JSON_encode( $root );

?>

The crux of it is:

    $focus = &$focus[$name];

because it facilitates moving deeper and deeper into the array. 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.