RE: [PHP-WIN] Re: Page-style data display system

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