Hi Green,
I tried using SQL_CALC_FOUND_ROWS as suggested by you. I am executing
some other queries following the query that has the clause
SQL_CALC_FOUND_ROWS. The documentation says in such a case we can save
the row count using *|SET @rows = FOUND_ROWS(); |*How can I retrieve
this row count
Harini Raghavan <[EMAIL PROTECTED]> wrote on 10/05/2005
11:21:26 AM:
> Hi,
> I have implemented pagination for the search functionality in my
> application. Since I have a lot of data, I thought in memory paging
> would not be a good option and opted for paging at the database layer.
> To do th
In the last episode (Oct 05), Harini Raghavan said:
> I have implemented pagination for the search functionality in my
> application. Since I have a lot of data, I thought in memory paging
> would not be a good option and opted for paging at the database
> layer. To do this I am retrieving the no o
