RE: [PHP-DB] MySQL category tree db sorting

2004-03-19 Thread Galbreath, Mark A
quot;"; } } } print " "; } ?> I'm sure this can be refactored, but I don't know PHP well enough to optimize it right now. Cheers! Mark -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED] Sent: F

Re: [PHP-DB] MySQL category tree db sorting

2004-03-19 Thread John W. Holmes
From: "Age Bosma" <[EMAIL PROTECTED]> > I'm trying to work out what the most efficient way will be to get the > complete tree structure from top to bottom of a category tree db. Search the archives or Google for "nested sets". That's going to be the most efficient database scheme to use. Any pare

RE: [PHP-DB] MySQL category tree db sorting

2004-03-19 Thread Hutchins, Richard
I'd recommend you search the PHP archives for an answer. This question comes up a few times a year and the last time I remember seeing it, somebody (John Holmes, I think) provided an excellent discourse on the different ways to approach this solution. You'll probably get other new responses with r