Hi, couple of notes:
On Sun, Apr 13, 2008 at 4:29 PM, Robert Jordan <[EMAIL PROTECTED]> wrote: > Execute the command "select FOUND_ROWS()" on the same connection. Make sure you don't execute another query in between, or FOUND_ROWS() will return the number of rows from that query instead. > Note that if your select is using "LIMIT", you must use the > SQL_CALC_FOUND_ROWS options: Not necessarily: you may actually want the number of rows returned by the query *with* the limit (e.g. FOUND_ROWS() for LIMIT 0,10 would return *at most* 10, not the total number of rows before the limit). But by and large that's the way to go. :) -- Lauri Kotilainen Email: [EMAIL PROTECTED] _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
