palace Posted March 7, 2007 Share Posted March 7, 2007 As you can probably tell from the question I'm relatively new to all this so apologies in advance. I'm trying to put together an online catalog (similar to shopping cart but with no pricing) I have a need for categories and then sub categories. I have discovered the hierarchial database model where the catagory table will look similar to | ID | CATEGORY | parentID | What I'm having difficulty with is trying to visualize how to do an admin page to put data into this table? Any ideas? Quote Link to comment Share on other sites More sharing options...
rofl90 Posted March 7, 2007 Share Posted March 7, 2007 Can you not just call the data from within PHP from MySQL? Quote Link to comment Share on other sites More sharing options...
suzzane2020 Posted March 7, 2007 Share Posted March 7, 2007 for the hierarchial order the parent id for the categories wub be 0 so the first entry(category) wud be insert into tblname(catgeory,parentid) values('category',0) When adding a sub category for this record..u need to select the categories,take the id and assign that as the parent id for the subcategory. i hope this dint sound confusin Quote Link to comment Share on other sites More sharing options...
willpower Posted March 7, 2007 Share Posted March 7, 2007 or invest in a program like phprunner ...look it up! 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.