in reply to Populating an array from a mysql select
The point is that fetchrow_array only fetches a single row. You want to use fetchall_arrayref instead.
Warning: untested
my @userlist = map {$_->[0]} @{$select->fetchall_arrayref};
--
wetware hacker
(Qualified NLP Practitioner and Hypnotherapist)
In Section
Seekers of Perl Wisdom