A group count question
| From: | Dave Carrera | Date: | Sat, 14 Sep 2002 19:19:33 +0000 |
| Subject: | A group count question | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-21758@lists.php.net to get a copy of this message | ||
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