> Great tip Brent! Thanks. I second that - I had no idea this useful function existed.
- B. On 10/18/07, Dell Sala <[EMAIL PROTECTED]> wrote: > 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. > > > -- 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 > _______________________________________________ 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
