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
