List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 26 2000 3:09pm
Subject:Re: Select Total Row Count AND LIMIT at same time???
View as plain text  
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
Thread
Select Total Row Count AND LIMIT at same time???Jeff Fitzgerald26 Jan
  • Re: Select Total Row Count AND LIMIT at same time???Paul DuBois26 Jan