push'ing to a hash array ref

Hi there,

got a hasharray ref from a mysql query

col_a -> "val1" col_b-> "val2"
col_a -> "val3" col_b-> "val3"

and I use it:

foreach $row ($@hash_ref))
{
$newval=$row->{col_a}++; #whatever
# do some work
....
}

But afterwards I need to 'add' a new hasharray to this ref. How can I do it?

push? how?


trellick

Not quite clear on what you mean by hasharray. Do you mean an array of hashes, or a hash of arrays?

hi there,

to be honest, I'm not quite sure of the terminology, but as far as I understand an array of hashes.....

i.e. I call a query to mysql within perl

$hash_ref=$myquery->fetchall_arrayref( {col_a=>1, col_b=>1});

This query in mysql could return thousands of 'rows'. [hash arrays?] but always, of course with the same column names [keys?].

In this case 'col_a' and 'col_b'

So the vary in $hash_ref after the call is a reference to an array of hashes(?)


Sorry to be vague,



trellick.

if your using the fetchall_arrayref(), this maybe a bit easier.



Mickalo

Thanks,


but how do I 'add' [push] new rows to this hash array ref??



trellick

Hi there,

I've got a solution:

push(@{my_href},{"col_a"=>$new_a_val, "col_b"=>$new_b_val});



thanks


trellick