Re: how many of a kind
one further question:
in the categories table, I've an "is_active" field.
What if I want to SELECT only where is_active=1?
How should be changed this?
SELECT COUNT(product_name) FROM products GROUP BY cat_id ORDER BY cat_id
Is it possible? Thanks! |