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
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
