I am sure this question has been posted here before, but a search has proven inconclusive.
I am hoping for some help.
I am building an event calander. I wish to show the up-coming week of events on my splash page. I have a table that is a date formatted row, 2005-03-07.
I would like to select everything from today up-to 7 days from today in a single querry. I have tried a few things out without the results that I am looking for, most querries i have tried do not discriminate between yesterday and tomarrow.
query = "SELECT * FROM tblEvents WHERE tblEvents.`date` <= CURDATE()+7";