Counting db results?

M

matt shudy

Hi,

Is there a way to make a custom query to count the records
returned by the db? I have a search results page that
filters out results by month and by year, I want a count
of the records that changes based on what the user chooses.

Thanks,

Matt
 
C

Chris Kasten

matt shudy said:
Hi,

Is there a way to make a custom query to count the records
returned by the db? I have a search results page that
filters out results by month and by year, I want a count
of the records that changes based on what the user chooses.

Thanks,

Matt
Click to expand...

Perhaps a custom query like:

Select count(*) from myTable
where stuff = ::fieldonForm:: and otherStuff = ::eek:therFieldonForm::

might work?
 
Top