--- 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
> >   Another sub-category
> > Another category
> > Sub-category
> > 
> > Any way to do this, without using a huge number of
> queries?  Using MySQL.
> This comes upon the list every few weeks.  Check the
> archives for more
> information.
> Basically, in MySQL there is no way to do it without
> using a large number of
> queries if you have the traditional table layout
> with a record_id and a
> parent_id in each, so that the table relates to
> itself.

There is one way - grab the entire table and loop it
into a multi-array and process it with PHP. 


So all subcats of category_id 5 are in 

Of course this will not be the best approach for large
category structures.

You can use basically the same code flow as the
recursive loop Paul posted to go thru this array.
instead of query for subcats you already have them in
the array.

Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to