php help

[flemingmike]

hi, i was wondering if anyone had a code that i could have for when a database entry gets entered, it will remove itself after 3 hours?

 

i have a page where someone creates a question and it currently takes a timestamp. i would like to put in my page where you view the questions the code to check all timestamps in the table, and remove any that are older than 3 hours.

 

table is called 'findamatch' table is called 'timestamp'

 

thanks.

[Maq]

Have another column in your DB to keep track of when it was inserted and run either a cron job or scheduled task, depending on what OS your server is on, and if it's 3 hours or older, delete it.

[flemingmike]

i tried this... didnt work:

 

$fam=mysql_query("SELECT id,clan,rules,month,day4,year,hour,min,ampm,timezone,teamid,ladder,maxbet,aim,email,yim,timestamp FROM findamatch ORDER BY timestamp");
while(list($id,$clan,$rules,$month,$day4,$year,$hour,$min,$ampm,$timezone,$teamid,$ladder,$maxbet,$aim,$email,$yim,$timestamp)=mysql_fetch_row($fam)){


$deleterow=$timestamp;
mysql_query("DELETE FROM findamatch WHERE NOW() - 25 MINUTE > '$deleterow'");

[flemingmike]

this seems like it should be so simple..  am i missing something stupid?