Subtracting Variables

[mparab]

Hello,

I have a little situation. I have a variable where I store a date. Actually a weekending date ie: 2003-08-31. What I want to do is to subtract days from this variable so I can get a date. For example:

If the variable is equal to say: 2003-08-31
I want to subtract say: 14 days
So that my answer will be: 2003-08-17

Anyone have any ideas????????

I'll post my query so you can see what I'm working with.

$result=mysql_query("SELECT * FROM timesheet WHERE (uname='$arr[uname]') AND (date BETWEEN '$arr[week]' AND '2003-12-31') AND (date >= '2003-01-01') ORDER BY date desc " ,$db);

Thanks In Advance,
M😃

[barand]

$var = '2003-08-31';
$var_14 = date('Y-m-d' , strtotime("$var -14 days"));
echo $var_14;

hth

[Benny_Johnson]

Yeah, what he said =)

[mparab]

K,

that works great thanks. But I can't get the sql query to give me a response. Any ideas.

M

[barand]

Try to avoid calling fields 'date' as it's a reserved word. If you do use it, put backticks round it

SELECT * FROM timesheet WHERE (uname='$arr[uname]') AND (date BETWEEN '$arr[week]' AND '2003-12-31') AND (date >= '2003-01-01') ORDER BY date desc

hth