Re: Best way to handle PREVIOUS and NEXT processing of database records retrieved

You could always use the LIMIT functionality in MySQL SELECT * FROM table LIMIT 0,25 Then just pass the variables for the limit to start at and how many you want returned in your query. SELECT * FROM table LIMIT $start,$num_returned So looking at records 26 through 50 your links would look like below. <a href="file.php?start=51&num_returned=25">Next</a> | <a href="file.php?start=0&num_returned=25">Previous Just make sure you check your variables so they are numbers to avoid any kind of SQL injection. On 1/26/06 2:27 PM, "Sue" <skot1@twcny.rr.com> wrote: > I am retrieving records from a MySQL database and need to just display each > record one after the other on a page. I only want to display a maximum of > 25 records per page though, and am wondering if there is a way to handle > this easily within PHP? I'd like to use something like NEXT and PREVIOUS as > links to go back and forth from each of the pages if there is more than 1 > page of data to display. Any examples/ideas would be greatly appreciated. > > Thanks in advance!