Re: Select Total Row Count AND LIMIT at same time???

[Paul DuBois]

At 12:11 AM -0500 2000-01-26, Jeff Fitzgerald wrote:
>	Hello,
>
>	Trying to build that famed ol' search engine. Working on 
>results page. Right now, I first select
>the total number of records found and then do another select using a 
>limit of 10 records each page.
>This way I have a number at the top of each page that says "236 
>records found".
>
>	Now, is there a way that I can do just one select, prep and 
>execute and get the same results??


No.

-- 
Paul DuBois, paul@stripped