RE: [PHP] Multiple pages of data.

<<Prev 1 2 3 Next>> tutorial at phpfreaks.com: http://www.phpfreaks.com/tutorials/73/0.php HTH Graham. -----Original Message----- From: Silvio Porcellana [mailto:sporc@tin.it] Sent: 29 September 2004 10:53 To: php-general@lists.php.net Subject: Re: [PHP] Multiple pages of data. You can solve it totally with SQL, using the FOUND_ROWS() function [http://dev.mysql.com/doc/mysql/en/Information_functions.html] I think this is the most efficient way of doing it... HTH, cheers Silvio Porcellana Nick Patsaros 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