[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-windows
Subject:    Re: [PHP-WIN] Re: Page-style data display system
From:       Raul IONESCU <ionescu.raul () gmail ! com>
Date:       2006-01-20 16:33:36
Message-ID: d8b847d0601200833q26b7a367id3679bcb420b2c0b () mail ! gmail ! com
[Download RAW message or body]

Or just try this: http://www.phpclasses.org/browse/package/2832.html
It's very easy to use.

On 1/20/06, Wayne Khan <kzhiwei@singnet.com.sg> wrote:
> Hi Daniel,
> You won't need something so complicated as PEAR or what.
>
> http://www.phpfreaks.com/tutorials/43/0.php
>
> Try out this tutorial. Its how I got my damned pagination code working. :)
>
> -----Original Message-----
> From: El Bekko [mailto:elbekko@gmail.com]
> Sent: Sunday, January 15, 2006 5:58 AM
> To: php-windows@lists.php.net
> Subject: [PHP-WIN] Re: Page-style data display system
>
> Daniel Anderson wrote:
> > Okay, I have a database table to which contains posts from people.
> > I want to retrieve these and post them in a linear format (as I currently
> have), but...! I want to have pages, each page has 50 rows from the database
> at a time.
> >
> > If I have 102 results, I want it to be separated into three pages.
> >
> > Page: 1, 2, 3
> >
> > The page link I want to be displayed in the URL as a variable: page=1
> (example).
> >
> > Each row is ordered with a primary key
> >
> > page=1    will return the first 50 results (1 - 50)
> > page=2    will return the next 50 results (51 - 100)
> > page=3    will return the next two results (101 - 102)
> >
> > I want a system that will automatically do this. I want the page numbers
> to increase along with how many results are in the database. At the moment
> there are only three, but in time it will grow. So essentially it should
> start off at Page: 1, then increase as I hit the 50th entry.
> >
> > Is there anyone who can help me with this?
> > If you need more detail, please email me and I'll try to explain more
> in-depth!
> >
> > Many thanks!
> > I hope you can help!
> >
> > Thanks for your time all!
> >
> >     ~Dan
>
> Try something to the likes of this:
>
> <?php
>
> $pageid         = intval($_GET['page']);
> $startlimit = ($pageid - 1) * 50;
> $endlimit       =  $pageid * 50;
>
> mysql_query("SELECT * FROM yourtable LIMIT $startlimit , $endlimit");
>
> ?>
>
> --
> PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit:
> http://www.php.net/unsub.php
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[prev in list] [next in list] [prev in thread] [next in thread]