Calendar Logic Help

I'm having problems getting my head around some login for a calendar. Specifically, the problem is drawing weekly views for events that span multiple days. I've gotten it so that if an event starts in the week being viewed, the days draw correctly for the remainder of the week. However, if the event goes into the next week, its start date is now outside my date range and so it doesn't display. I know how to say the logic, I'm not sure how to write it! The logic would be: if any date between the start and end dates of the event are within the week being displayed, show the event. I'd like to put the logic into my MySQL query so I don't have to get all events from the calendar to see what should be displayed. Any ideas? Thanks! Floyd