View old records (timestamp)

[leetkrew]

hello there. How to view / list records that are 1 hour old or older?

here's my database structure:

id | timestamp | verification_code | ...

PHP5 / MySQL

please help thanks.

[leetkrew]

got it.. anyway here's the code if someone here needs it.

// delete images older than 30 days
$records_to_delete = time() - 2592000;
$sql = "DELETE FROM `images` WHERE `timestamp` < " . $records_to_delete ;
$db->db_query($sql);

hope it helps