Returning number of rows

[eluser]skunkbad[/eluser]
Before I posted the code I stripped out parts that were necessary for search. My code just shows that the query for the count and the query for the data can be done in the same method. You may find that when your queries become more complex you end up going with something like this. Whatever works works!