my $timenow = time(); $minutes = $minutes * 60; my $timemin = $timenow - $minutes; my $data = qq(DELETE FROM now_time WHERE lasttime < "$timemin"); my $sth = $dbh->prepare($data); $sth->execute() or die $dbh->errstr; my $day = 60 * 60 * 24; my $timeday = $timenow - $day; my $data = qq(DELETE FROM day_time WHERE lasttime < "$timeday"); my $sth = $dbh->prepare($data); $sth->execute() or die $dbh->errstr;