View Single Post

   
  #8 (permalink)  
Old 02-28-2008, 09:46 AM
Stefano Perna
 
Posts: n/a
Default 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!
Reply With Quote