[thelist] SQL Loser

r937 rudy at r937.com
Tue Aug 12 08:27:07 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();

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


rudy
http://r937.com/





More information about the thelist mailing list