There is also a decent looking article (haven't yet studied it in any detail though) on pagination at http://www.phpfreaks.com/tutorials/43/0.php David Eisenhart "Richard Hutchins" <Richard.Hutchins@Getingeusa.com> wrote in message 1EA7D3AE70ACD511BE6D006097A78C1E033C89FF@USROCEXC">news:1EA7D3AE70ACD511BE6D006097A78C1E033C89FF@USROCEXC... > Mike, > > If you check www.phpclasses.org, and search for "paging" there's a paging > class built by pierre-yves lemaire that might do just what you're looking > for. It's pretty highly rated by the users of the site. > > I also know this question has been asked in the past so a stroll through the > archives may yield additional leads on other sites such as freshmeat and > phpbuilder. > > Good luck, > Rich > > > -----Original Message----- > > From: mike karthauser [mailto:mikek@brightstorm.co.uk] > > Sent: Thursday, March 06, 2003 1:32 PM > > To: php-db@lists.php.net > > Subject: How to page results? > > > > > > We've been working on a news section for our site which > > allows us to find > > news stories -> dump them in a mysql db, list the summaries > > in a page and > > then link to a full version of the story. > > > > The bit i'm having trouble with is how to list the results so > > we can set up > > multi pages of content and link them via a simple > > > > Previous | 1 2 3 4 5 | Next > > > > type of scenario. > > > > I got a query thus > > > > $result2=mysql_num_rows($result); > > > > to count our results. Does anyone have any pointers on what > > to do next? > > > > Cheers > > mikek > > > > -- > > Mike Karthauser > > Managing Director - Brightstorm Ltd > > > > Email >> mikek@brightstorm.co.uk > > Web >> http://www.brightstorm.co.uk > > Tel >> 0117 9426653 (office) > > 07939 252144 (mobile) > > > > Snailmail >> Unit 8, 14 King Square, > > Bristol BS2 8JJ > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
