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