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 Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/139860-solved-database-design/#findComment-731708 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.