Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re: creating an array from MySQL results

by rnahi (Curate)
on Oct 30, 2005 at 19:21 UTC ( #504024=note: print w/ replies, xml ) Need Help??


in reply to creating an array from MySQL results

Your code should work as it is.

The advice I can give you is the same you may find at Before asking a database related question ..., where it is outlined how to test your SQL before resorting to the script.

Additionally, you may see some different ways of creating an array from a DBI call in DBI Recipes.

My favorite is :

my $arrayref = $dbh->selectcol_arrayref($query);

HTH


Comment on Re: creating an array from MySQL results
Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://504024]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (7)
As of 2015-07-07 00:32 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (86 votes), past polls