romio Posted March 2, 2006 Share Posted March 2, 2006 Am not sure how to ask this, am suppose to create my database as the following, user access admin panel, then can Add, Delete, Edit Categories, also the user can create subcategories of the root category, also add product for each category, i am not really familiar with trees in sql, all my previous work was straight forward, no trees, I did read Joe Celko's Trees and hierarchies in SQL for smarties for Adjacency List Mode but i didn’t really understand how can i build my database, can anyone help out.Thanks. Quote Link to comment Share on other sites More sharing options...
trq Posted March 2, 2006 Share Posted March 2, 2006 You might want to have a read of [a href=\"http://www.phpriot.com/d/articles/php/application-design/nested-trees-1/index.html\" target=\"_blank\"]this[/a] article on implimenting nested sets in php. Depending on exactly how your using your trees, nested sets can be more efficient than the adjacency model. Quote Link to comment Share on other sites More sharing options...
romio Posted March 2, 2006 Author Share Posted March 2, 2006 The article was very helpfull, ok so lets say that i want to build this two tablesCategories and prodcut and Categories consist of Cat_nameproduct consist of:Pro_DI, Name, Description.So will I have to create two tables or one table? Quote Link to comment 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.