selecting a date range

floydiology · #1 (**permalink**) 03-08-05, 00:01

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.
example:
query = "SELECT * FROM tblEvents WHERE tblEvents.`date` <= CURDATE()+7";

HELP!!!!A date range query will save my life!!!!

r937 · #2 (**permalink**) 03-08-05, 08:04

Code:

 where tblEvents.`date` 
       >= current_date
   and tblEvents.`date` 
       < date_add(current_date, interval 7 day)

floydiology · #3 (**permalink**) 03-08-05, 23:28

This is slightly different than all the various versions of this query I have tested out, I knew I was getting twisted with it... I will try this out...THANKS!

Internet Services

Web Development

Digital Marketing

Consumer Tech