dispalying data per page

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
softsolvers
Forum Commoner
Posts: 75
Joined: Fri Feb 13, 2004 4:26 am
Location: India

dispalying data per page

Post by 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
markbeadle
Forum Commoner
Posts: 29
Joined: Tue Dec 02, 2003 2:50 am
Location: Aachen, Germany

Post by markbeadle »

This topic has already been discussed within the forums... you could perform a search :wink:

To sum up if you are using a database you could use limit and offset within your SQL statement.

SELECT select_list
FROM table_expression
[LIMIT { number | ALL }] [OFFSET number]


(That is in POSTGRESQL).

Hope that helps
User avatar
DuFF
Forum Contributor
Posts: 495
Joined: Tue Jun 24, 2003 7:49 pm
Location: USA

Post by DuFF »

It's called "pagination". Check out this tutorial for some help:

http://www.phpfreaks.com/tutorials/43/0.php
mikegotnaild
Forum Contributor
Posts: 173
Joined: Sat Feb 14, 2004 5:59 pm

Post by mikegotnaild »

Yessum.. That is what i need to learn as well. :)
Post Reply