counting entries in a column
Posted: Thu Oct 25, 2007 3:22 am
Ok so i am listing entry's in this column and grouping them so its only displaying a category once using:
SELECT category FROM ida_projects GROUP BY category
beside each entry i want to have the number of entries that match that. So if there is 4 entries that are the category "static" then it will print a "4"
i think im close to getting it but i can never seen to get it right so i must be overlooking somthing. Any suggestions.
SELECT category FROM ida_projects GROUP BY category
beside each entry i want to have the number of entries that match that. So if there is 4 entries that are the category "static" then it will print a "4"
i think im close to getting it but i can never seen to get it right so i must be overlooking somthing. Any suggestions.