$sth = $dbh->prepare( "something" ) 
  || die "Error: " . $dbh->errstr;
$sth->execute()
while ( my $ref = $sth->fetchrow_hashref() )
    {
        print "$ref->{something}";
    }
}

##</code><code>##

$single_scalar = $sth->something();