[RESOLVED] Adding/Subtracting from Current Day's Date

Let's say today's date is 2006-06-01.

How would I get data for the previous week without having to specify it? For example, the following wouldn't work:

$enddate=date(Ymd);
$startdate=date(Ymd)-6;
SELECT data FROM table WHERE date BETWEEN '$startdate' AND '$enddate'

I want $startdate to be equal to 2006-05-26. Is this possible?

Something like this?
SELECT data FROM table WHERE date BETWEEN CURDATE() AND (CURDATE() - 6)

Heck yeah as long as it understands that CURDATE() - 6 is 2006-05-26. I'll give it a try.

Any way to enter that date into a variable for output so the user knows what date range they're looking at for the set of data that gets returned?

$enddate = date('Y-m-d');
$startdate = date('Y-m-d', strtotime('-6 days'));

Perfect! Thanks.