close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Need help with Categories and Sub Categories

Thread began 3/30/2009 9:37 am by wrigleydon259291 | Last modified 5/24/2010 11:06 am by wrigleydon259291 | 4275 views | 6 replies

Ray BorduinWebAssist

Add a categoryParent field to the category table. Set it to zero for main level categories, and set the categoryID to subCategories.... then you need to ask yourself do all subcategories exist in only one category?

That would of course also effect your database structure... but you don't want to make things so complex that you go over your head, so consider carefully.

If you did want subcategories to exist within different subcategories, or products to exist within different subcategories.. these decisions would go into how you would structure your database.

For instance if products could exist in more than one category, then you wouldn't have a categoryID as part of the product, instead you would have a productCategories table that included the categoryID and the productID so that one product could be listed in more than one category.

Similarly if you had more than one parent category for a subcategory, then you would not add the parentID to the category table and instead you would create a parentCategory table with the parentCategoryID and childCategoryID so that those too could exist in more than one structure. But of course these things will all complicate the creation of the administrative section to update the necessary information properly and easily.


Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...