How to use MySQL Found_Rows() in PHP?
SQL_CALC_FOUND_ROWS is only useful if you’re using a LIMIT clause, but still want to know how many rows would’ve been found without the LIMIT. Think of how this works: SELECT SQL_CALC_FOUND_ROWS * FROM Users; You’re forcing the database to retrieve/parse ALL the data in the table, and then you throw it away. Even if you … Read more