* Matthias Ludwig <[EMAIL PROTECTED]> [2006-10-18 09:05]: > On every category- and article-page there should be a "way to > the top" with links to every base-category (up to the root). In > the database every category has a id, base_id and a name (<=100 > chars). Every article has category_id that references the > category.
You can fetch the entire hierarchy with a single query: http://www.developer.com/db/article.php/3517366 See also http://www.google.com/search?q=nested+set in general. Regards, -- Aristotle Pagaltzis // <http://plasmasturm.org/> _______________________________________________ List: [email protected] Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/[email protected]/ Dev site: http://dev.catalyst.perl.org/
