want to restrict the number of results displayed at one time

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
nutstretch
Forum Contributor
Posts: 104
Joined: Sun Jan 11, 2004 11:46 am
Location: Leicester

want to restrict the number of results displayed at one time

Post by nutstretch »

I have a database which and code which works well and reteieves everything i need.

Some of the results are large and I would like to restrict the amount seen at any one time. I would like to use next and previous links to scroll through the results.

Does anyone have any good pointers fo me to be looking at. I presume i may be able to do this using counters or something.

Any help appreciated

Nuts
User avatar
Dr Evil
Forum Contributor
Posts: 184
Joined: Wed Jan 14, 2004 9:56 am
Location: Switzerland

Post by Dr Evil »

The technique often used is to change the LIMIT $offset,$end in your SQL query.

You can find a tutorial here:http://www.hotscripts.com/PHP/Tips_and_ ... index.html
Post Reply