[Resolved] SELECT (this time 7 days ago) ?

[Kold]

Hello.

How can i select data from a database where the MySQL timestamp is 7 days ago or older?

I have read something about Date('Y', 'last week') but I dont really know what i'm doing!

Thanks for your time!
K.

[bubblenut]

Here is a list of available MySQL date/time functions and here is a list of PHP functions. Try and knock something together on your own first and if you get stuck post back and I'll see what I can do.

[Kold]

Thanks, but my initial worry of days and months (not so much years) rolling over. I can get the correct times 1 week ago, but the problem occurs when the last date was say, the second of the month. The SQL syntax the gets everything prior to this, but it wont roll over to the 31st etc to get everything prior to the second.

SELECT *
  FROM 
tblTempMail
  WHERE 
DAY (`Temp_Time`) < '5'
  AND 
MONTH( `Temp_Time` ) < '4'
  AND 
YEAR( `Temp_Time` ) < '2005'

I hope you understand my problem.
Thanks.

[xblue]

Kold, you can just have mysql do it for you, should work like

  WHERE date_column < NOW() - INTERVAL(1 WEEK)

[Kold]

Thanks.

I couldnt get it to work, but it put me in the correct direction 🙂