[Mono-list] Num Rows

Robert Jordan robertj at gmx.net
Sun Apr 13 09:29:40 EDT 2008


Dimitris Zenios wrote:
> Does anyone know how can i do a mysql_num_rows query with mono?

Execute the command "select FOUND_ROWS()" on the same connection.

Note that if your select is using "LIMIT", you must use the
SQL_CALC_FOUND_ROWS options:

"select SELECT SQL_CALC_FOUND_ROWS * from table limit 10"

Robert



More information about the Mono-list mailing list