From memory ... I don't think you can do it in SQL (but I very well
may be wrong), at least on the query-end.
It's probably best to approach it by restructuring the tree when you
insert/update, though that's going to be a good deal of hairy code in
your business logic.
Sorry I don't have a better answer.
-Tim
On Jul 31, 2008, at 12:06 AM, Marc Antony Vose wrote:
Hey there:
I had a category structure that was previously limited to two
degrees, but I've decided that I want it to be able to grow however
it needs to. I has been using a "parent" field previously, and I
converted it to be stored using a typical nested set model, so that
I could achieve display with a single database query, and so forth.
I now have a slight problem, which is that I would like the
categories to be alphabetized in each level. Has anyone previously
tackled this problem before, and have some sample code to rebuild
the entire tree, but alphabetize or sort the entries in each level?
Cheers,
Marc Vose
Suzerain Studios
http://www.suzerain.com
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
