The last iteration, `while ($row = $result->FetchRow()) {` does include an option to use associative arrays to manage a multi select list with both display and value or a non-associative array for just values which will be used to as text display in the select widget.

AdoPivotReportType.php

<?
public static function getVariableOptions($params, &$report) {
    $report->conn->SetFetchMode(ADODB_FETCH_NUM);
    $query = 'SELECT DISTINCT '.$params['column'].' FROM '.$params['table'];

	if(isset($params['where'])) {
		$query .= ' WHERE '.$params['where'];
	}

    $macros = $report->macros;
    foreach($macros as $key=>$value) {
        if(is_array($value)) {
            foreach($value as $key2=>$value2) {
                $value[$key2] = mysql_real_escape_string(trim($value2));
            }
            $macros[$key] = $value;
        }
        else {
            $macros[$key] = mysql_real_escape_string($value);
        }

        if($value === 'ALL') $macros[$key.'_all'] = true;
    }

    //add the config and environment settings as macros
    $macros['config'] = PhpReports::$config;
    $macros['environment'] = PhpReports::$config['environments'][$report->options['Environment']];

	$result = $report->conn->Execute(PhpReports::renderString($query, $macros));

	if (!$result) {
		throw new Exception("Unable to get variable options: ".$report->conn->ErrorMsg());
	}

	$options = array();

	if(isset($params['all']) && $params['all']) {
        $options[] = 'ALL';
    }

    while ($row = $result->FetchRow()) {
        if ($result->FieldCount() > 1) {
            $options[] = array('display'=>$row[0], 'value'=>$row[1]);
        } else {
            $options[] = $row[0];
        }
    }

    return $options;
}

loop.php

<?
while ($row = $result->FetchRow()) {
    if ($result->FieldCount() > 1) {
        $options[] = array('display'=>$row[0], 'value'=>$row[1]);
    } else {
        $options[] = $row[0];
    }
}