Query of registered users by date.
Development and Programming
I would like to create a query that will list the number of users within a specific membergroup, and display the count of users that registered on each day. (And the list grows with each new day)
For instance:
25July2011 - 138 26July2011 - 41 28July2011 - 35
What I have so far is this (it shows the dates (not grouping yet, and shows every date) :
{exp:query sql="SELECT join_date FROM exp_members WHERE group_id = '5'"}{join_date format="%d %M %Y"} {/exp:query}
Thanks!
Bumping this request…anyone???
Sorry about the delay in response, this should help:
{exp:query sql="SELECT join_date, COUNT(*) as signup_count FROM exp_members GROUP BY FROM_UNIXTIME(join_date,'%d%m%y') ORDER BY join_date"}
{join_date format="%d %F %Y"} - {signup_count}
{/exp:query}Let me know how it goes!
PERFECT!
Any idea how to show a specific range with this (excluding the registrations of administrators for instance which happened long before site launch)
Yep you’d just add a WHERE clause to only pull a certain member group, and only join_dates between a certain range, just search for ‘mysql between’ - you’ll learn faster if you read up on it yourself 😉