select result from multiple date ranges

[venkatadapa]

Hi friends,

 

I want a solution for how to get resutls from multiple date ranges, The actual requirement is users creates events in my site with multiple date ranges each event have mutliple dates see my tables structure below

 

I have the following data;

    events

      eventid      title      description

      1                salsa    salsa dance

      2                party    party for all 

 

  event_schedules

      eventid  start_date    end_date

      1              12-12-2009  15-12-2009

      1              18-12-2009  23-12-2009

      2              2008-01-17  2008-01-20

 

here in event_schedules table eventid is the reference from events table, I want a query for how to get today playing event. Ex: if today is 14-12-2009 how can i get the event from the date ranges that is playing today.

I need this very urgent please help me if anybody have an idea.

 

Thanks in advance 

[ngreenwood6]

is this what you are looking for;

 

$cur_date = '14-12-2009';
SELECT * FROM table WHERE start_date <= $cur_date AND end_date >= $cur_date