Re: Getting MySQL Data into an Array.


Do you know where your variables are?
	PerlMonks

by miyagawa (Chaplain)

on Jan 06, 2002 at 15:27 UTC ( #136673=note: print w/replies, xml )

Need Help??

Try this:

@companies = map { $_->[0] } @{$dbh->selectall_arrayref('SELECT compan
+y FROM company_public')};
[download]

--
Tatsuhiko Miyagawa
miyagawa@cpan.org

Comment on Re: Getting MySQL Data into an Array. Download Code

Replies are listed 'Best First'.
Re: Re: Getting MySQL Data into an Array. by Anonymous Monk on Jan 06, 2002 at 23:37 UTC
Wow... that is very neat.	[reply]
Re: Re: Getting MySQL Data into an Array. by cdherold (Monk) on Jan 07, 2002 at 08:34 UTC
thanks for opening my mind. that's a cool one.	[reply]
(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 ')};` [download] 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)	[reply] [d/l]

Domain Nodelet^?

Node Status^?

node history
Node Type: note [id://136673]
help

Chatterbox^?

How do I use this? | Other CB clients

Other Users^?

Others scrutinizing the Monastery: (3)

As of 2023-10-04 22:38 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

No recent polls found

Notices^?