function sanction_deleteSanction($sanctionId, $teacherId) {
    $dsn = new dsn();
	$db = $dsn->dsn_connect();
    
    $res = $db->query("SELECT * FROM sanctions WHERE sanctionId = ?", $sanctionId);
    if (PEAR::isError($res)) {
        return NULL;
    }
    $sanctions_row = $res->fetchRow(DB_FETCHMODE_ASSOC);
    
    $res = $db->query("SELECT category FROM sanctionReason WHERE sanctionId = ?", $sanctionId);
    if (PEAR::isError($res)) {
        return NULL;
    }
    $reasons_row = $res->fetchRow(DB_FETCHMODE_ASSOC);

    if ($sanctions_row['parentSanctionId'] > 0) {
        $db->query("UPDATE sanctions SET status = 'Active', parentSanctionId = 0 WHERE parentSanctionId = ?", $sanctions_row['parentSanctionId']);
    } 

    $res = $db->query("UPDATE sanctions SET status = 'deleted', dateStamp_history = NOW()  WHERE sanctionId = ?", $sanctionId);
    if (PEAR::isError($res)) {
        return NULL;
    }

    if (sanction_syncPunishments($db, $sanctions_row['studentId'], $teacherId)) {
        return TRUE;
    } else {
        return FALSE;
    }
}