| View previous topic :: View next topic |
| Author |
Message |
aababu
Joined: 04 Jun 2008
Posts: 78
|
 Posted: Thu Dec 17, 2009 3:57 am Post subject: Select result from multiple date ranges in mysql |
 |
|
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.
Thanks in advance |
|
| Back to top |
|
 |
venkatadapa
Joined: 12 May 2008
Posts: 280
|
| Posted: Fri Dec 18, 2009 3:22 am Post subject: |
|
|
Try with this query
$cur_date = date('Y-m-d');
SELECT * FROM table WHERE (start_date=$cur_date or (start_date < $cur_date AND end_date >= $cur_date))
The above query will retrieve the results from db whose startdate = today or today is withing the dateranges.
Good Luck., |
|
| Back to top |
|
|
|
