Date Range Query

[[deleted]]

I have a table named tblworkouts. This table contains running workouts for up to three groups. That is to say a row may have a traininggroup_id of 1, 2, or 3. The issue I'm running into is that I want to display the all of the workouts for all groups, but only for the upcoming week, but not beyond or before.

If I run something like
select * from tblworkouts where workoutdate between '2003-03-25' and '2003-03-26'

then I get the desired results. For the first date I can simply create a variable called $today. The real problem I'm having is generating the value for the second value.

Any suggestions?

[xblue]

a little confused, "between '2003-03-25' and '2003-03-26'" not really is a week?

however you could either use a variable generated in php or CURDATE() for the current date, and add some days to it for the end date like

select * from tblworkouts where workoutdate between '$today' and add_date('$today', interval 7 day)

[Pig]

You can also use strtotime() to easily create the date before hand

$next_week = date("m/d/Y", strtotime("+1 week"));

[[deleted]]

xblue's suggestion worked although it's date_add not add_date.

Thanks for your help.