Displaying db results in mult pages SO:VED with thanks in final post

[niche]

I've never written code that displays db results in mult pages. I found the LIMIT clause at: http://dev.mysql.com.../en/select.html and thatseems to be the critical code to solve my problem. I'd like to know if there's an easierapproach that wouldn't involve LIMIT to display db result in mult pages? EDIT: My thinking would turn the offset of the first row to return and and the maximum numberof rows to return into variables of course .

Edited June 25, 2012 by niche

[Don E]

Are you referring to pagination?

[niche]

Yes. Shows how much I don't know about it.

[birbal]

you need to do like this

SELECT CALC_FOUND_ROWS *.......LIMIT 0,10

immidiately after executing this you have to execute FOUND_ROWS() which will give the total found rows which you can use to determine the number of pages.

[niche]

Thanks for your help Don E and birbal.