update. where time < (30 minutes ago) ?

[jwk811]

$sql = "UPDATE message
SET status = 'new'
WHERE post_time < (x)";

 

i want it to change the status to 'new' for every message that was posted less than 30 minutes ago

[schilly]

what's the data type of post_time in that table?

[jwk811]

datetime

[schilly]

try this

 

$sql = "UPDATE message
SET status = 'new'
WHERE post_time >= FROM_UNIXTIME(" . time() - 60*30 . ") ";

 

there should be a way directly in mysql but i'm not totally sure on the syntax.

 

you can look at the date/time f'ns in mysql here: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html

[jwk811]

uh didnt work. still all old

[schilly]

This should work too

$sql = "UPDATE message
SET status = 'new'
WHERE post_time >= DATE_SUB(NOW(), INTERVAL 30 MINUTE) ";

 

Did you try a select to see if it matched any rows?