$names = $select->fetchall_arrayref();
    foreach $names ( @$names) {
        ($variable1, $variable2, $variable3) = @$names;
}