How about the following:
foreach my $row_ref (@{$array_ref}) {
print @{$row_ref}, "\n";
}
The above loop will print all the rows, each row has its own line, and there
is no space between two values in a row though.
Bao
Brad wrote:
> I've been struggling with this and getting nothing but gibberish.
>
> my $array_ref=$sth->fetchall_arrayref()
>
> I can't get anything out of $array_ref though, I can't work out how to
> manipulate it.
>
> The query was "select filename, size, score from files where
> codeID=\"".$codeID."\" which should return about 3-100 rows of data
> depending on the codeID, I then want to put into @filearray, @sizearray,
> @scorearray. So far I've only managed to pull what looks like hex.
>
> Any help GREATLY appreciated. I'm using mysql, on RH 6.2
--
BAO RuiXian, PROGRAMMER, Technologies Team, Project Services Group
AtBusiness Communications Corp., Kaapeliaukio 1, FIN-00180 Helsinki
tel. +358-9-2311 6674, mob. +358-50-329 6275, fax +358-9-2311 6601
http://www.atbusiness.com, email: [EMAIL PROTECTED]
