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@xxxxxxxxxxxxxx> 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@xxxxxxxxx] > Sent: Sunday, January 15, 2006 5:58 AM > To: php-windows@xxxxxxxxxxxxx > Subject: 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
