Hi all,
how to retrieve Number of logins during the week.
This is the number of times users have logged in last week.
Say in June 08 if i want the results i should be able retrieve as
weekly_logins = [‘june 1 2008 100’,‘june 7 2008 150’, ‘june 14 2008
210’, ‘june 21 2008 180’…]
My Table for users_logrecords, columns are
id,user_id,login(1-true,0-false),last_updated
1 1 1 2008-06-23 23:23:38
1 1 0 2008-06-23 24:23:30
is there any sql for retreieving the count from particular Month
thanks !!!