rubing Posted April 22, 2008 Share Posted April 22, 2008 I am trying to return all rows in the range of this upcomming week. So, I am using CURDATE() and (CURDATE() + 7). Unfortunately it is not working. Is there something wrong with this query? SELECT DISTINCT MusicEvents.Band, Venue, BandSite, Category, HomeTown FROM MusicEvents LEFT JOIN Bands ON MusicEvents.Band=Bands.Band WHERE Date BETWEEN CURDATE() and (CURDATE() + 7) ORDER BY Venue ASC, Source ASC, MusicEvents.Band ASC Link to comment https://forums.phpfreaks.com/topic/102429-return-rows-for-the-next-week/ Share on other sites More sharing options...
fenway Posted April 23, 2008 Share Posted April 23, 2008 There is... 7 what? WHERE Date BETWEEN CURDATE() and (CURDATE() + INTERVAL 7 DAY) Link to comment https://forums.phpfreaks.com/topic/102429-return-rows-for-the-next-week/#findComment-524812 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.