in reply to How to check for new records in mysql database every minute
my $min_old = time-60; my $sth = $dbh->prepare("SELECT * FROM table WHERE timestamp>$min_old" +); [download]
cLive ;-)