Gijs is a full time Dutch student in economics and a spare time Web developer. He spends his time developing scripts using PHP, MySQL and other external programs. Visit him at http://gvtulder.f2o.org/
Storing Hierarchical Data in a Database, Part 3
This entry is part 3 of 3 in the series Storing Hierarchical Data in a DatabaseAutomating the Tree Traversal Now that you’ve seen some of the handy things you can do with this table, it’s time to learn how we can automate the creation of this table. While it’s a nice exercise the first time […]
Storing Hierarchical Data in a Database, Part 2
This entry is part 2 of 3 in the series Storing Hierarchical Data in a DatabaseModified Preorder Tree Traversal Now, let’s have a look at another method for storing trees. Recursion can be slow, so we would rather not use a recursive function. We’d also like to minimize the number of database queries. Preferably, we’d […]
Storing Hierarchical Data in a Database
Whether you want to build your own forum, publish the messages from a mailing list on your Website, or write your own CMS: there will be a moment that you’ll want to store hierarchical data in a database. Gijs explains two practical methods to do just that.