Implementing An N-Level Nested Tree In PHP And PostgreSQL, Part 1

Summary

In this article we implemented an n-level nested tree, including an SQL schema to represent the tree as well as example queries for looking up the data.

In the next article, we’ll implement the nested tree in PHP.

Other Options

• Download a PDF version of this article
• Put your PHP knowledge to the test with our online and iPad/iPhone quizzes
• View or post comments for this article
• Browse similar articles by tag: MySQL, PHP, PostgreSQL
• Read related articles:
  • Implementing An N-Level Nested Tree In PHP And PostgreSQL Appendix
  • Implementing An N-Level Nested Tree In PHP And PostgreSQL, Part 2