Hiding Categories

[Ajeh]

I am afraid you have an error in your SELECT as you are also picking up the Top Level categories_id that have subcategories in them ...

Is your intent to pick categories_id where there are active products "somewhere" within the branch or within the active products' active categories_id ...

[drrogera]

I am afraid you have an error in your SELECT as you are also picking up the Top Level categories_id that have subcategories in them ...

Is your intent to pick categories_id where there are active products "somewhere" within the branch or within the active products' active categories_id ...

The idea was to pickup any categories that had an active product somewhere below. So the idea was to get to the top as it were. I hope I got hat correct.

UNION queries are my favorite. When I see them I know the person has gotten deep into the guts of SQL. I never hire a DBA that cannot tell me where the Group By goes in a UNION query. So, if you know, don't write it here.

[WebMC]

Has any one got the code for this? I really cant be bothered to work it out - It should be an option in zen cart anyway....

[kobra]

Has any one got the code for this?

It is in post#11

I really cant be bothered to work it out

Then take it the way it is

It should be an option in zen cart anyway....

Can not be all things for all wants
That is why it is open source

[WebMC]

I wasn't looking for philosophy, i will take that as you dont know...

[kobra]

i will take that as you dont know...

post #11

[WebMC]

Basicallly I ran an sql code to disable any products which didnt have images and I am now finding empty categories on the menu. So it is pointless them being there. I dont want to do it manually as I process my data from a different database so a code to disable empty categories or just hide them on the menu is all i am looking for.

It's a great idea for a menu mod or just as core code in zen cart.
I can look into it if no one else has found the solution but i would prefer it if someone has already found out and is willing to contribute this information to the open source community of zen cart....

It is quite difficult though i think because you are counting subcategory counts aswell and looking at multiple tables....

[kobra]

so a code to disable empty categories or just hide them on the menu is all i am looking for.

My BAD it is Post #10 that has sql to return cats with active items and this can be used/altered to build upon

[WebMC]

Thanks I will take a closer look at that

[WebMC]

I was thinking more like


return $products_count;
if ($products_count <=0){$query="update " . TABLE_CATEGORIES . " set categories_status =0 where categories_id = ".$products->fields['categories_id']."";
$query = $db->Execute($query);}

in the functions_categories.php to update the status to 0 based on category count althought this code doesnt work