SQL Select Question

[NZ_Kiwis]

I want to select the rows added in the last 7 days, working to out from a Unix Time Stamp added into a column in each row.... how can I do this?

[coldwerturkey]

cant you just use somthing like...

SELECT * FROM table WHERE time >= '$sevendaysago'

and define $sevendaysago with mktime() and time()

[bpat1434]

Or you could use the DATE_SUB function from mysql....

SELECT * FROM `table` WHERE `time` >=DATE_SUB(`time`, INTERVAL 7 DAY)