[RESOLVED] MYSQL & Unixtimestamp

[BigDeezy]

I have a query that I need help with ...the current query says:

$query="SELECT * FROM motm where user_id='$for_id'";
$result= mysql_query($query) or die ("Could not execute query : $query." . mysql_error());

I need it to say:

$query="SELECT * FROM motm where user_id='$for_id' AND time<now()-INTERVAL 31"

What I'm trying to accomplish is for the results to only be rows that are older then 31 days. I also know this works if the time is in this format (ex.. 2007-08-29). But what about if the time is unixtimestamp (ex.. 1162022400). I hope this is understandable.

Can anyone please confirm or explain to me what I shoud do?

Thanx
Big D

[barand]

SELECT * FROM motm
WHERE user_id='$for_id'
AND FROM_UNIXTIME(time) < now()-INTERVAL 31 DAY

[bpat1434]

Still won't work... basically, what you want is:

SELECT *
FROM motm
WHERE user_id='$for_id'
  AND FROM_UNIXTIME(`time`) < DATE_SUB(CURDATE(), INTERVAL 31 DAY)

Alternatively, you could use:
1 MONTH
4 WEEK
as the intervals instead of just 31 DAY.

EDIT - Fixed SQL issue after re-reading the post.

[BigDeezy]

Thanks Barand ..it worked perfectly and thanks bpat for the alternatives.😃