Multiple pages of data.
| From: | Nick Patsaros | Date: | Wed, 29 Sep 2004 05:05:37 +0000 |
| Subject: | Multiple pages of data. | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-198149@lists.php.net to get a copy of this message | ||
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