[KinderClans]

Well if you're using MySQL you can do something like...

Код:

DELETE FROM houses WHERE houseid < (CURDATE() - INTERVAL 30 DAYS);

Or..

Код:

CREATE EVENT delete_event
ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 30 DAYS
ON COMPLETION PRESERVE

DO BEGIN
      DELETE houses WHERE houseid < DATE_SUB(NOW(), INTERVAL 30 DAYS);
END;

Or you can set a cronjob in your cPanel each 30 days, then link it to a .php file:

pawn Код:

<?php 
 include 'your_db_connection';
 mysql_query("DELETE FROM houses WHERE houseid < NOW()");
?>