[ic] How to create [same name] subcategories

Steve & Patti Getzinger steveandpatti@wubs.org
Tue, 03 Apr 2001 19:22:27 -0500

Ok think tree. On this tree we have branches. The Oak tree is not
related to the Maple except that they are trees. Now Our Oak tree is dog
products and a branch is food. Same for cat. Here are fields:

category	subcat	subcat1
dog	food	Purina
cat	food	Purina

Want to mine out only the cat Purina?


What this has done is scan the products file and first we look in the
category field for cat and we take all those listings and separate out
only the food entries in subcat. Now from there we only want the purina
entries in subcat1. Likewise if we wanted all entries for Purina in teh
subcat1 field we would simply:



"Gina K. Anderson" wrote:
> |How can I create subcategories?
> I still haven't bee able to figure out this little problem:
> Dog Products    (main)
>         Food            (sub)
>         Collars (sub)
>         Toys            (sub)
> Cat Products    (main)
>         Food            (sub)
>         Collars (sub)
>         Toys            (sub)
> I've pretty much thrown IC out of the loop because this is seems to be so
> difficult. Firstly, the admin needs to differentiate between the Dog Food and
> Cat Food, so a client can add products to either category without needing to
> make sure 'cat' or 'dog' is in the name of the product (so a search will turn up
> the right products-which doesn't always seem to work anyway).
> There are lots of stores that have something like this in the admin:
> Choose a category to add the product to:
> [drop down box lists:]
> Dog Products
> Dog Products->Food
> Cat Products
> Cat Products->Food
> It seems there is something in the data table structure that does not allow this
> to be done easily. Two people tried to help me out with this, but no solution
> seemed to work correctly.
> Gina
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users

  WDI                          Steve & Patti Getzinger
  702 Lincolnway West          steveandpatti@wubs.org
  South Bend, IN  46616        http://www.wubs.org/
  219-287-4700 (Main Office)   317-535-0239 (Direct Line)