difficult count statement
| From: | Merlin | Date: | Thu, 01 May 2003 20:16:06 +0000 |
| Subject: | difficult count statement | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-27473@lists.php.net to get a copy of this message | ||
Hi there,
I am running a mysql db and I would like to figure out how to count member
growth.
For a chart I would need the number of members who have registered each day.
Something like this:
count (*) AS c
WHERE
regdate = '20030501'
does not really make sense, since I would have to query the db for each day
making it dramaticly slow.
Has anybody an idea on how to get the numbers registered each day to fead a
graph with data?
Thank you for any help on this.
Merlin