NYCPHP Meetup

[Brian D.]

> Great tip Brent! Thanks.

I second that - I had no idea this useful function existed.

- B.

On 10/18/07, Dell Sala <dell at sala.ca> 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
>