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