--- Chris Elsworth <[EMAIL PROTECTED]> wrote:
> Use SQL_CALC_FOUND_ROWS.
> Documented in
> http://www.mysql.com/doc/en/SELECT.html
>
> You run your first query with SQL_CALC_FOUND_ROWS,
> then once you're
> done with it, you run another ("SELECT
> FOUND_ROWS()") and you get the
> total resultcoun
On Sat, Dec 27, 2003 at 02:08:08PM +, Abs wrote:
> hi
> i was trying to group my results 10 per page ($p per
> per page). if i use limit, then there's no way of
> knowing how many there are left so i can't give page
> numbers as:
> << first 2 3 4 last >>. perhaps running the query
> twice, firs
