Daily queries
Posted: Mon Apr 24, 2006 8:36 am
Hi I have a web site which allows members to register to it
When a user regsiters I store the date on whihc they do this.
From this data I now want to display how many memebers have signed up on each day since the site was launched, so I can display something like "2006-04-17 : 13 members" for each day
any ideas what sort of query i should run, was thinkin of using a distinct for the day then counting the number of registartions fromit?
thanks in advance
alex
When a user regsiters I store the date on whihc they do this.
From this data I now want to display how many memebers have signed up on each day since the site was launched, so I can display something like "2006-04-17 : 13 members" for each day
any ideas what sort of query i should run, was thinkin of using a distinct for the day then counting the number of registartions fromit?
thanks in advance
alex