You said:
--
is there a way to calculate the number of rows retrieved by a mysql query,
without actually performing it?
I want to make a paginated result like in most search engines, and for that
I need to display the number of pages
the result would have, but I do not wa
Got it,
Thanks to all of your replies!
W.D.F.
- Original Message -
From: "Cal Evans" <[EMAIL PROTECTED]>
To: "Walter D. Funk" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, July 16, 2002 11:44 AM
Subject: RE: Calculating rows in a result s
Walter D. Funk wrote:
>Hi everybody,
>
>is there a way to calculate the number of rows retrieved by a mysql query,
>without actually performing it?
>
>I want to make a paginated result like in most search engines, and for that
>I need to display the number of pages
>the result would have, but I
Not without actually performing SOME kind of query. You could
select count(*) from...
and insert the rest of your query there. This would give you the count.
Then store this in a session variable (PHP) for subsequent pages.
Most of the time though, I just put a NEXT button. ADODB has some gr