Purge mysql timestamps from 1 hour ago or older 1

[thedaver]

If MySQL 3.23.59 table is

create table formtokens
-> (ft_token char(34) not null unique,
-> ft_data char(255),
-> ft_touched timestamp(14),
-> index idx_ft_token (ft_token));

What is the PHP code to tell MySQL (via a function) to drop entries in this table that are older than 60 minutes??? It's harder than it appears. Do I convert to unix_timestamp!?

Surfinbox.com Business Internet Services - National Dialup, DSL, T-1 and more.

http://www.surfinbox.com/business/

 

[bastienk]

if you are doing this, then its best to store a unix timestamp and compare that to the current unix timestamp...there are some issues with mysql timestamps not working correctly when doing this type of function.

post code for record removal