dispalying data per page

[softsolvers]

hello friends
i like to display the data as the user inputs e.g. if user choose 10 per page then the page contents should change and the data should being displayed according to the page,same for the choosing 20/50 etc.
can u people help me

[parawizard]

whats your data layout look like and what type of data and how are you outputting it. more info and sample code need to really understand what you are doing 🙂

[ether_us]

If you're pulling your data out of a database like MySQL, check out the LIMIT keyword and it's syntax.

Say you have a script that'll list a bunch of users but you want to show 10 or however many per page, you can control the results through your SQL queries.

For example:

SELECT * FROM users LIMIT 10;

would give you the first 10 results, but if you wanted to show results 11-20 (say, the second page if you were showing 10 users at a time):

SELECT * FROM users LIMIT 10,10;

The first parameter is the offset, or where to start from and the second parameter is the number of how many results to return after that.

Hope this helps..

[softsolvers]

thanks i think your suggestion has solved my problem