Weekly logins

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 !!!

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs