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> =======================================================