Unnamed

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;    }}