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
