I believe you're looking for the fetchall_arrayref method. You can use it like this:

my $rows = $sth->fetchall_arrayref;
print "$_->{'name'} $_->{'age'}, $_->{'height'}" for (@$rows);
[download]

If the number of returned rows is huge however, you may want to fetch them one at a time, using fetchrow_hashref:

while (my $row = $sth->fetchrow_hashref) {
    print "$row->{'name'} $row->{'age'}, $row->{'height'};
}
[download]

Update: confused fetchall_hashref with fetchall_arrayref...

Try this-



while ( $ref = $sth->fetchrow_hashref() )
{
    print "$$ref{'name'} \t $$ref{'age'} \t $$ref{'height'}\n";
}
[download]

If so, it makes the most sense to do it in SQL, ie SELECT Name, Age, Height FROM table ORDER BY Height ASC. Then you could step through it row by row, regardless of the size of the dataset returned.

If it must be sorted in perl, you'll need to either use one of the "fetchall*" methods or loop through all rows to store the full result set before sorting.

HTH

Sorry
Title should be, "sorting return from fetchrow_hashref"
OK, I'm connecting to the database fine and I am getting back the right data into the hash ref because I've checked it using print Dumper $hashrow;
Now I need to know how to use the hash ref, to print out the data in a formatted sense using a foreach loop.
thanks.