arrays on the fly??? is it possible

[jamsman]

i need to create a number of arrays on the fly, i dont know how many as the results come back form a database

any ideas

anymore information required please ask

thanks

 

[ishnid]

Consider using two-dimensional arrays (arrays of arrays). With those, you can create as many arrays as you like and store them in the same data structure. Type `perldoc perllol' on the command line for a tutorial.

 

[jamsman]

thanks for the info

 

[TrojanWarBlade]

To follow up Ishnid's suggestions, if you create an array and you wish it to contain arrays of returned data and you don't know how many, all you need to do is loop collecting data from the db with something that returns an array reference like "fetchrow_arrayref" and push that returned value onto your array.

my $ref;
while($ref = $sth->fetchrow_arrayref()) {
  push @array, $ref;
}
# Here your main array contains all your rows of data each as an array

Does that help?


Trojan.

 

[jamsman]

thats great i think i have enough to go on now

cheers

 

[TrojanWarBlade]

You might also like to use a module called Data:umper so that you can examine the data whilst you are developing the code (or you could always use "perl -d" and display your data structure with the "x" command!).


Trojan.

 

[jamsman]

i have used the Data:umper alot really helpfull i find thanks for the advise