Posted by Phil Latio on 02/02/07 20:39

> Unfortunately you can't do that with a single SQL statement (unless you
> use a nested set structure, but that would be real overkill). You have
> to walk up the tree in a loop and fetch every parent node until you
> reach the root node.

Thanks for your answer.

Cheers

Phil

• Next in forum: Re: I have sub-categories but want to display full category path
• Prev in forum: Re: PHP 4.4.4 vs Perl 5.8.7 for Object Oriented server code
• Thread view: Re: I have sub-categories but want to display full category path

[Reply to this message]