Your not totally lost on it, your very cloes to your solution. Keep track of the LIMITs with php, and not mysql. Pass the LIMIT information to the next page, and use some aritihitc to determine the next and prvious limits for the link... so you would have a var called $limit possibly, and your next and previous links will pass this var + or - the number of posts per page, so next would be $limit + 15......
Jason Nick Patsaros <[EMAIL PROTECTED]> wrote: > > I'm trying to build a bulletin style system right now. I have topics > and replies to each topic. If a topic gets more than 15 replies I > want them to start carrying over onto page 2 and then 3 and so on with > 15 replies per page. > > The key that I'm missing I guess is, how do I keep track of the last > accessed row in the database? So if I run a LIMIT 15 I can go back > and pick up where I left on previously? Using the primary key isn't > going to help because if posts get deleted I would have less than 15 > per page. > > Maybe I'm totally lost on this though, if someone could give me a bit > of help on the most efficient way to accomplish this. > > --Nick > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
