Flushing database values

[maxsslade]

i havfe a database which logs users sessions to a database. I want the database to delete these values every hour without human intervention.

how could i do this?

• Max

[Quevas]

Using PHP you could check let say... when a user click on submit, if an hour is elapsed and then delete the records.
Anyway PHP works through users interaction not automatically.

[Sxooter]

Time oriented operations are generally considered outside the realm of what a database does, and should generally be handled by a cron job.

It's pretty simple. Put a creation timestamp field into your table, then every 5 minutes or so, run a cron job that deletes rows that are >1 hour old. i.e.

$now = time();
delete from table where tstamp<'($now-86400)'

kinda thing (not sure that's the correct syntax, but you get the idea.)