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 !!! -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---