Pagination Question

[WeakestLink]

In order to do Pagination I could only think of two methods. First off I am using PHP as my server side scripting.

So Currently I run a MySQL Statement. To get a Total Count of records that fit the query.

Then I run the same exact Query but I add a Limit Statement to me. To me this seems excessive and not efficent so i though would it be better to just run the query once and then allow PHP to create limits.

Any thoughts on this? How are you doing Pagination?

[earl-grey]

so i though would it be better to just run the query once and then allow PHP to create limits.

No. Check out SQL_CALC_FOUND_ROWS

[WeakestLink]

Thanks man that was so key!