Hi,

How to count rows WHERE category="x" AND date BETWEEN (first d of month)
AND (last d of month) for every day?

For category='x' in march 2011:

Looking for something like that:
day count
1 3
2 7
...
31 4


Best regards.

On 02/26/2011 11:09 PM, L wrote:
Put all of this in one line in your browser's URL address field:

http://dev.mysql.com/doc/refman/5.1/en/
group-by-functions.html#function_count

W dniu 2011-02-26 23:18, Robert Hairgrove pisze:
not so hard as i fought