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
dispalying data per page
Moderator: General Moderators
- softsolvers
- Forum Commoner
- Posts: 75
- Joined: Fri Feb 13, 2004 4:26 am
- Location: India
-
markbeadle
- Forum Commoner
- Posts: 29
- Joined: Tue Dec 02, 2003 2:50 am
- Location: Aachen, Germany
This topic has already been discussed within the forums... you could perform a search
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
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
It's called "pagination". Check out this tutorial for some help:
http://www.phpfreaks.com/tutorials/43/0.php
http://www.phpfreaks.com/tutorials/43/0.php
-
mikegotnaild
- Forum Contributor
- Posts: 173
- Joined: Sat Feb 14, 2004 5:59 pm