Hi, I'm having trouble with an array of references. I'm reading rows from a MySQL database, and using fetchrow_arrayref to get a reference to an array containing each field. I'm then trying to push this reference onto another array called @returnme, which ends up holding a reference to an array for each of the rows returned. This is the code I have:

    while ($result = $sth->fetchrow_arrayref)
        {
        $before.= $$result[0];
        push (@returnme, $result);
        }
    
    $after.= ${$returnme[0]}[0];
    $after.= ${$returnme[1]}[0];
[download]

(There are only 2 records in the DB right now.) When I display the contents of $before, I get the values of the first field of each returned row. But when I display the contents of $after I just get the first field of the second row, repeated twice. Also, I tried changing the first value directly with ${$returnme1}[0] = "HI"; which results in $after returning "HIHI" instead of only modifying one value - the same happens if I go for element 0 instead of 1. It can't be a referencing problem if it works both ways right? I have no idea why this is happening, if anyone could give me some advice that would be fantastic.