php-db | 2002091

[PHP-DB] A group count question From: Dave Carrera (dave <email protected>)
Date: 09/14/02

Hi All

I have a table that I would like to show some stats based on num
messages collated to date posted.

I think I need something like

Count(replies) where date= month(dateposted)

But its probaly wrong.

All I need is to show that say that in month 8, 500 messages were sent
and in month 9 300 messages were sent and so on.

Can someone please help with some guidence or samples.

Using MySql and php 4.2+ usinf datetime stamp for the date col.

Thank in advance

Dave C 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php