Counting rows returned from a SELECT with perl DBI.

[Brian Seitz]

I am creating a web-front end to search for database entries and I want
to split the output into more than one screen (limit 1 , 20, limit 21 ,
40, etc.)  But in order to know when to stop allowing the user to press
"next" and get another screen of results when there are no results left,
I need to return how many total results exist without the limit
statement.  Is there a better way to do this than executing the
statement without the limit and doing a count loop (i.e., "while
$row_ref = $sth->fetchrow_arrayref { $i++ } )?  It seems like there
should be some DBI function that returns this automatically.