[Resolved] need help wuth two dates

[phpjaco]

after reading through most of the "dates" post I have tries the following:

i have a message posted on a mysql db, I want to let the messages not show after 14 days, but having trouble with my query statement.

first my date_submit was a timestamp but I have changed it to a date so it would work easier, here is my statement:

$sql2 = "select * from message where msg_group = '$staff_group' AND (DATEDIFF(now ,time_created) < 14)";

what am i doing wrong here? i get a "not a valid mysql statement " error.

please help. im pretty sure its just a syntax error.

[devinemke]

$two_weeks_ago = date('Y-m-d', time() - 1209600);
$sql = "SELECT * FROM message WHERE date_submit > '$two_weeks_ago'";

[phpjaco]

ok looks like its working. just wondering what is the - 1209600 for?

it is a time format but how does it work for if i say want to shorten the days?

thanx

[devinemke]

Originally posted by phpjaco
ok looks like its working. just wondering what is the - 1209600 for?

it is a time format but how does it work for if i say want to shorten the days?

1209600 = 60 x 60 x 24 x 14
(the number of seconds in 14 days)

[phpjaco]

so its ...
60 sec in a min. 60 min. in hour 24 hour a day * 3 days
for 3 days : 259200

thanx