--- 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 resultcount you would have got, had you not > LIMIT'ed it.
thanks. i didn't know there was such a function. nice. now all i've to do is get the site hosting ppl to upgrade to 4.x :P fortunately, in this case, the table to browse will always be scanned entirely so my big set is the number of rows of the table (there's no where clause). so the SHOW TABLE STATUS FROM db LIKE tbl will do. 'Rows' has what i need. just in case anyone else was in a similar situation. abs ________________________________________________________________________ Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
