[RESOLVED] Selecting Rows by Time Period

[Tim_Silva]

Hi,

How should I do my SELECT so that it will give me a random row from the current date up to 7 days back?

AT this point I am doing it manually but I know it is not the right way to do it because I would have to change the date everyday:

("SELECT * FROM $usertable WHERE date > '2007-06-11' ORDER BY RAND()")  

Thanks,

Tim

[devinemke]

SELECT * FROM table WHERE date > DATE_SUB(CURDATE(), INTERVAL 7 DAY) ORDER BY RAND()

[Tim_Silva]

Thanks Devinemke.

Tim