subtenante ha scritto:

>
> Ask MySQL exactly how you asked us :
>
> SELECT COUNT(product_name)
> FROM products
>
> where is_active=1
>
> GROUP BY cat_id ORDER BY cat_id



one moment:
is_active is in the categories table (not in products)!