Page 1 of 1

want to restrict the number of results displayed at one time

Posted: Thu Feb 19, 2004 8:36 am
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

Posted: Thu Feb 19, 2004 9:17 am
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