Hello, There is an EXCELLENT article at MySQL.com that talks about storing hierarchal data, which is exactly what you want to do. The theory is not MySQL specific, so you can apply it to any database system. It covers two techniques, one of which Philip Thompson covered, and another that I prefer. Well written and a recommended read for everyone.
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html -K. Bear -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
