Re: Counting rows returned from a SELECT with perl DBI.

[Brian Seitz]

> Maybe I do not entirely understand the question, but I
> see a simple solution to what I think the question is
> about ( provided your database does not get updated in
> between the searches, or such updates is something you
> do not consider):
> 
> select count (*) from my_table  before show the first
> result set.
> store the total number of records in the hidden input
> and use it for later queries.

Oh, sorry.  I forgot to mention that my SELECT statement has about five
WHERE conditions in it, so I know that COUNT(*) doesn't work. 
Basically, I suppose I'm asking how can I get the same functionality of
COUNT that works with WHERE conditions?