help with time

[jasondavis]

I have a time that shows as 2008-01-29 16:57:01

$line_reply['submit_date'];

shows as 2008-01-29 16:57:01 I need to subtract 10 minutes from this $line_reply['submit_date'];

[bogu]

Something like this:

echo date("Y-m-d H:i:s",strtotime("-10 minutes", strtotime($line_reply['submit_date'])));

[bradgrafelman]

Or you could simplify it and have MySQL return the new date using the DATE_SUB() function:

SELECT DATE_SUB(submit_date, INTERVAL 10 MINUTE) AS submit_date, ...

[jasondavis]

SO here what I have, im getting really confused, im trying to make an if statement where if a user posted a message in the past 10 minutes they are allowed to edit it but it 10 minutes is up then they can no longer edit it

$line_reply['submit_date'] = '2008-02-01 16:57:01';
$current_date = date("Y-m-d H:i:s");
$submit_date2 = date("Y-m-d H:i:s",strtotime("-10 minutes", strtotime($line_reply['submit_date']))); 

[bogu]

if(mktime()>strtotime("+10 minutes",strtotime($line_reply['submit_date']))) {
    /* u cant edit */
} else {
    /* u can edit */
}

or directly from MYSQL

UPDATE `table` SET
`field` = 'field_value'
WHERE (`submit_date` + INTERVAL 10 MINUTE) < NOW()

[jasondavis]

bogu wrote:

if(mktime()>strtotime("+10 minutes",strtotime($line_reply['submit_date']))) {
    /* u cant edit */
} else {
    /* u can edit */
}

Hi thanks for the reply, I tried this version but it seems to always show "u cannot edit" no matter when the mysql value is posted