Selecting values from a week of current date

[luminous]

I've got a table with some values in and a datetime field (fieldname: time). I want to be able to select the values from the current time (NOW()) until a week into the future.

I've tried:

 

SELECT * FROM dd_restriction WHERE (time(NOW(), INTERVAL 7 DAY))

 

But it's not working  :'( what am I doing wrong?

[jdavidbakr]

Your "where" clause isn't doing any comparison.  You need something like

 

SELECT * FROM table WHERE date >= now() and date <= date_add(now(), interval 7 day)