[thelist] SQL Loser
Fred Jones
fredthejonester at gmail.com
Tue Aug 12 08:41:53 CDT 2008
>> In order to get the number of results, however,
>> in order to be able to page the results, ...
>
> use SQL_CALC_FOUND_ROWS in the outer query and then follow with
>
> SELECT FOUND_ROWS();
Oh, great--never knew about that.
> by the way you might want to change your joins to INNER JOINs
>
> i'm pretty sure they'll produce the same results, and might run faster
OK.
Thanks!
More information about the thelist
mailing list