how do i select all rows from table where timeStamp is older than 7 days of current date

[carlfaulkner]

I have a field timeStamp within my table which is type timestamp with a format 2011-09-30 23:11:12.The attribute is on update current_timestamp.can i run an sql command to select all rows that are older than 7 days from date when command is executed.something like select * from tbl where timeStamp < current_timestamp - 30

[justsomeguy]

You can use date_sub to subtract 2 dates.http://dev.mysql.com/doc/refman/5.1/en/dat...nction_date-add

[carlfaulkner]

r u able to write an sql statement that would do this...

[justsomeguy]

Yes I am, are you? If not, I'll help you out. Start with the examples on that page in the manual.

[carlfaulkner]

i apoligise...took a while looking at the above link but i've got it. Thank you.

[carlfaulkner]

i apoligise...took a while looking at the above link but i've got it. Thank you.

SELECT *FROM tblWHERE DATE_SUB( CURDATE( ) , INTERVAL 5DAY ) >= timeStamphow could i do the above but set a variable such as $expiry = "5" and replace INTERVAL 5 with INTERVAL $expiry. would that work.

[justsomeguy]

If you're using PHP, just use the variable in the query string. Check here for examples of using variables in strings:http://www.php.net/manual/en/language.type....string.parsing