Rails find Conditions

Hi, I am trying to return all the records in my table for which a date
comparison reveals that that date is within 7 days. The code I have
written looks like this:

@subscriptions = find(:all, :conditions => ['subscriptions.user_id = ?
AND subscriptions.confirmed = 1 AND (DATEDIFF(day,now(),events.start_on)
< 7)',user_id], :joins => "INNER JOIN events on subscriptions.event_id =
events.id")

@subscriptions = find(:all,
:conditions => ['subscriptions.user_id = ? AND subscriptions.confirmed = 1
AND events.start_on >= ?', user_id, 7.days.ago.at_beginning_of_day],
:joins => "INNER JOIN events on subscriptions.event_id = events.id")

-philip