[RESOLVED] Time() with PHP/Mysql

[savj14]

I am inserting data using Time() as one of the rows. My issue is I only want to retrieve the data within an hour of the current Time.

How do I go about creating an IF statement to Select only the data that is equal to or less than an hour from the current time?

[coldwerturkey]

I believe this will work

$query = "SELECT * FROM table WHERE thetime >= ".(time() - 60*60);

[savj14]

That worked thanks for the help =)