Printing array

[Wiinie]

I am new in Perl. and I am still very confused about printing the array..

my $object = Language->new();
        #my $language = Language->id();
                my $language_id = $db->selectall_arrayref("select languageId, languageName
                                                                                from language");
 
 
 
                foreach my $i (@$language_id){
                my ($id, $name ) = @$language_id;
                $object->id($id);
                $object->name($name);
                push (@language, $object);
 
                @return=[@language] ;
 
                        foreach my $current(@return){
                        my $id = $current->id();
                        my $name = $current->name();
                        print "ID: [$id]  Name: [$name] \n";
                        }
                }
 
@return=[@language] ; <= this is a problem____
 

because at the 1st time that I do not have this line of code @return=[@language] ;
it will print those stuff
ID: [ARRAY(0x31fcac4)] Name: [ARRAY(0x31fca84)]
ID: [ARRAY(0x31fcac4)] Name: [ARRAY(0x31fca84)]
...


if i make the @language is reference.

 
        @return=[@language] ;
 
                        foreach my $current(@return){
                        my $id = $current->id();
                        my $name = $current->name();
                        print "ID: [$id]  Name: [$name] \n";
                        }
                }
 

it will give me an error is
"Can't call method "id" on unblessed reference at C:/user/...."



Please help

Thank so very much

[miller]

Quick advice, don't use $db->selectall_arrayref(..sql..) unless you're more familiar with perl and complex data structures. Instead iterate over your result solutions instead using.

my $sth = $db->prepare("select languageId, languageName from language");
$sth->execute or die $db->errstr;
 
while (my ($id, $name) = $sth->fetchrow_array) {
    print "$id, $name\n";
}

As for your other issues, I can't understand your code and your problem as it stands right now.

- Miller

PS
Enclose your code in [code]your code here.[/code] tags