On Sat, Mar 24, 2012 at 7:41 AM, Jay Blanchard
<jay.blanch...@sigmaphinothing.org> 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 );
>>
>> ?>
>>
>> Cheers,
>> Rob.
>> --
>
> At first blush I'm not sure how this would work - but I haven't had any
> coffee yet either. I'll give this a shot in a little while. Seems almost too
> easy.
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
This has been fascinating to read. I hope you get it figured out, Jay!
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
