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? Link to comment https://forums.phpfreaks.com/topic/41694-admin-page-for-adding-categories/ 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? Link to comment https://forums.phpfreaks.com/topic/41694-admin-page-for-adding-categories/#findComment-202084 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 Link to comment https://forums.phpfreaks.com/topic/41694-admin-page-for-adding-categories/#findComment-202088 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! Link to comment https://forums.phpfreaks.com/topic/41694-admin-page-for-adding-categories/#findComment-202115 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.