Re: [GENERAL] Equivalent for mysql's FOUND_ROWS()

2004-05-21 Thread Jan Wieck
Victor Spång Arthursson wrote: With mysql it's possible to add a parameter "SQL_CALC_FOUND_ROWS" to the selectstatement and then after having made a query to the database with a limit clause you can fire off a second query, "SELECT found_rows() as numberofrows" to get the number of rows the quer

[GENERAL] Equivalent for mysql's FOUND_ROWS()

2004-05-20 Thread Victor Spång Arthursson
With mysql it's possible to add a parameter "SQL_CALC_FOUND_ROWS" to the selectstatement and then after having made a query to the database with a limit clause you can fire off a second query, "SELECT found_rows() as numberofrows" to get the number of rows the query would have returned without