NYCPHP Meetup

[Dell Sala]

On Oct 18, 2007, at 5:08 PM, Brent Baisley wrote:

> You don't need to do an extra count query. If you are using MySQL,
> just add SQL_CALC_FOUND_ROWS to your select query.
> SELECT SQL_CALC_FOUND_ROWS * FROM ...
>
> You can then run SELECT FOUND_ROWS() to get the total rows without any
> limits. It's still 2 queries, but the second one is essentially free.

Great tip Brent! Thanks.

-- Dell