RE: [PHP-DB] How to page results?
| From: | Hutchins, Richard | Date: | Thu, 06 Mar 2003 18:37:53 +0000 |
| Subject: | RE: [PHP-DB] How to page results? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-26132@lists.php.net to get a copy of this message | ||
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: [PHP-DB] 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
>