numero = 50547
interpreted = N
texte = on 21/5/03 4:38 pm, Marc Kaiwi at marc@kaiwi.com wrote:> You're surely on the right track as you've described below but why do > you need a categories database to cross reference the category numbers > in the products db? The reason for doing this is so that categories can be added independently of the products database. i.e. We may want to keep the footwear category for when we get new stock in.Another reason for this is that in our admin area you can choose a category you want a product to be displayed in when you are adding it.I wouldn't know exactly where to start with changing the logic to add the CAT instead of the ID to the products.db.Sorry... I'm still not to savvy with WebDNA yet....MHO call it what it is in the products db. > > Just as you've described you're going to simply nest a few searches to > build a list of categories containing their respective products. > > good luck, > > On Wednesday, May 21, 2003, at 08:26 AM, Alan White wrote: > >> Hi Everyone >> >> I am currently trying to add additional search features to our site >> and am >> trying to figure out how to make a menu that pulls out only the >> Categories >> (i.e.. footwear etc) that are in the products database and have an >> inventory >> of > 0. >> >> I haven't even tried to get the if inv > 0 working yet as it is the >> next >> task, all I want to be able to do at the moment is pull out the >> available >> categories and I should be able to do a lot of what I am trying to get >> done >> (here's hoping anyway). >> >> My products db is like follows:- >> >> ID SKU ... ... ... BRAND CATEGORY ... ... etc >> 1 blah 8 3 >> >> I have a Categories database which is just :- >> >> ID CAT >> 1 Footwear >> 2 Accessories >> etc >> etc >> >> I have successfully pulled all of the categories into a menu using the >> categories.db but then I realised this wasn't a very good idea as you >> may >> not have product in each category. >> >> This is the code I used:- >> >> ---------------------------------------------------- >> >> [search db=admin/category.db&neIDdatarq=find_all&CATEGORYsort=1] >> >>