aliento Posted January 7, 2009 Share Posted January 7, 2009 Hi programmers. I always had problem with the database tree for a directory application. I want to make a directory for business companies and with the ability to store there products in it. I want to save to the database categories subcategories , this i will do it with one table with ids , levels and previous level ids. The companies will be stored to another table with the category id which is under. Plus i want to store products which are different for every company. Every company will have a lot of products. The amount of the products i hope will be a lot . Its a problem to store them in one table. What should i do? do you find any problem at what i told? Thank you Link to comment https://forums.phpfreaks.com/topic/139860-solved-database-design/ Share on other sites More sharing options...
Daniel0 Posted January 7, 2009 Share Posted January 7, 2009 Take a look at the modified preorder tree traversal (also called nested set). http://dev.mysql.com/tech-resources/articles/hierarchical-data.html Link to comment https://forums.phpfreaks.com/topic/139860-solved-database-design/#findComment-731708 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.