How do I get multiple rows?

[Scott Phelps]

Here's what doesn't work:

my $dbh=DBI->connect('dbi:ODBC:scottp', 'user', 'pass',
                {RaiseError => 1,
                AutoCommit => 1}
                ) || errorhandler("Database connection error: $DBI::errstr");

$sth=$dbh->prepare("SELECT $content_field FROM $content_table WHERE page= ?
AND type= ?");
$sth->execute($content_page, $content_type);
@content = $sth->fetchrow_array;
$dbh->disconnect();

This of course returns an array (actually only one element) of the first row
that satisfies my SQL statement.
Is there a way to get the specific field of multiple rows that match my
criteria into an array?

______________________________________
splehP ttocS
rotartsinimdA smetsyS TN
secivreS tenretnI renroKbeW
moc.renrokbew@pttocs
moc.renrokbew.www

$a="@ARGV";while($a){$a=~s/(.$)//;$b=$b.$1;}print "$b\n";
______________________________________