in reply to Re: Getting MySQL Data into an Array.
in thread Getting MySQL Data into an Array.

thanks for opening my mind. that's a cool one.
  • Comment on Re: Re: Getting MySQL Data into an Array.

Replies are listed 'Best First'.
(jeffa) 2Re: Getting MySQL Data into an Array.
by jeffa (Bishop) on Jan 07, 2002 at 10:08 UTC
    Yes, that is indeed cool, but don't let your boss catch you using that. DBI has a method that will return a column for you:
    my @companies = @{$dbh->selectcol_arrayref(' SELECT company FROM company_public ')};

    jeffa

    L-LL-L--L-LL-L--L-LL-L--
    -R--R-RR-R--R-RR-R--R-RR
    F--F--F--F--F--F--F--F--
    (the triplet paradiddle)