Re: Can This be done

Hi,

I know that select return a number of records, but i i use
LIMIT i can't know how many row actualy is, because it's
alway smaller than limit.

Only solution I know for now is with 2 queryes. First query
to get all the data, and than second with limit. But this is
not something i want.

--
bye,
 Uros                            mailto:uros@sir-mag.com


Monday, May 13, 2002, 7:47:01 PM, you wrote:

SL> On 5/12/02 3:22 PM, "Uros Gruber" <uros@sir-mag.com> wrote:

>> Hi!
>>
>> Is it possible for example I have one db with 100.000
>> entries. I select some data, let say about 1.000. Now i want
>> this data show on page by pages.
>>
>> I use limit and ofset for this. But how can i know how much
>> is all the records. Because i want to print also how many
>> hits were but i don't want get all the rows at once.
>>
>> Is there any function for this or i have to make 2 queries.

SL> In most implementations I've seen, which is mostly middleware such as PHP,
SL> if you aren't going to get all the rows at once, you need two queries. The
SL> "function" that you want, that tells you the number of rows matching
SL> criteria X, is, after all, a SELECT statement ... :->

SL> -- sgl


SL> =======================================================
SL> Steve Lane

SL> Vice President
SL> Chris Moyer Consulting, Inc.
SL> 833 West Chicago Ave Suite 203

SL> Voice: (312) 433-2421       Email: slane@fmpro.com
SL> Fax:   (312) 850-3930       Web:   http://www.fmpro.com
SL> =======================================================