who use SQL_CALC_FOUND_ROWS how use it in phalcon?
About the only time I've ever used that feature is when I'm doing pagination. With Phalcon, it has it's own pagination functionality, so I just use that.
ok. If i have query whith 10 joins, how count rows? Copry query with COUNT(...)?
About the only time I've ever used that feature is when I'm doing pagination. With Phalcon, it has it's own pagination functionality, so I just use that.
The Pagination functionality can accept any query.
If you're not using pagination, you have to run a second query: SELECT FOUND_ROWS()
FOUND_ROWS() return 0 (
The Pagination functionality can accept any query.
If you're not using pagination, you have to run a second query:
SELECT FOUND_ROWS()