query("INSERT INTO archiv_shorttimeemployments SELECT * FROM `shorttimeemployments` WHERE archivdate < CURRENT_DATE;") ;
$db->query("DELETE FROM shorttimeemployments WHERE archivdate < CURRENT_DATE;");
$db->query("INSERT INTO archiv_shorttimeemployment SELECT * FROM `shorttimeemployment` WHERE archivdate < CURRENT_DATE;");
$db->query("DELETE FROM shorttimeemployment WHERE archivdate < CURRENT_DATE;");
$db->query("INSERT INTO archiv_shorttimeemployment SELECT * FROM `shorttimeemployment` WHERE TO_DAYS( enddate ) - TO_DAYS( startdate ) >90 AND shorttimeemployment.jobfields LIKE '%childcare%';");
$db->query("DELETE FROM shorttimeemployment WHERE TO_DAYS( enddate ) - TO_DAYS( startdate ) >90 AND shorttimeemployment.jobfields LIKE '%childcare%';");
$db->query("INSERT INTO archiv_shorttimeemployments SELECT * FROM `shorttimeemployments` WHERE TO_DAYS( enddate ) - TO_DAYS( startdate ) >90 AND shorttimeemployments.jobfields LIKE '%childcare%';") ;
$db->query("DELETE FROM shorttimeemployments WHERE TO_DAYS( enddate ) - TO_DAYS( startdate ) >90 AND shorttimeemployments.jobfields LIKE '%childcare%';");
?>
Note: Please click
here if your browser does not redirect in 4 seconds.