on 3/26/03 9:18 PM, Leif K-Brooks at [EMAIL PROTECTED] appended
the following bits to my mbox:
> I have a table with a tree. Thing is, I need to generate a view of it like:
> Category
> Sub-category
> Sub-sub-category
> Another sub-category
> Another category
> Sub-category
>
> Any way
If I understand correctly and you have the data all in one table,
you can just query all the data that goes into the report, sorted
by categories, and output the data in a loop. This code will give
you an ordered list indented and numbered by level. It's not
perfect, but give you the idea...
$qstr
--- Paul Burney <[EMAIL PROTECTED]> wrote:
> on 3/26/03 9:18 PM, Leif K-Brooks at
> [EMAIL PROTECTED] appended
> the following bits to my mbox:
>
> > I have a table with a tree. Thing is, I need to
> generate a view of it like:
> > Category
> > Sub-category
> > Sub-sub-category
> > Ano
Also just saw a new PEAR package posted that helps you
work with nested sets. Haven't tried it yet.
http://pear.php.net/package-info.php?package=DB_NestedSet
olinux
--- Paul Burney <[EMAIL PROTECTED]> wrote:
> on 3/26/03 9:18 PM, Leif K-Brooks at
> [EMAIL PROTECTED] appended
> the following bits
What's your table structure look like? I've done this in a couple projects.
I use a parent child relationship. Usually I make it so you can expand and
collapse the tree by clicking on a plus or minus, the script I've attached
doesn't have this feature for simplicity sake.
parent child descriptio
Craig --
...and then Craig Kohtz said...
%
...
% The script I've included works for a table named "structure" with the
% following fields:
Sounds interesting. Care to actually post the script? ;-)
I'd like to see it.
TIA & HAND
:-D
--
David T-G * There is too much anim