Page-style data display system

Hi Daniel,
You won't need something so complicated as PEAR or what.



Try out this tutorial. Its how I got my damned pagination code working. :)

Message
From: El Bekko [mailto:elbekko (AT) gmail (DOT) com]
Sent: Sunday, January 15, 2006 5:58 AM
To: php-windows (AT) lists (DOT) php.net
Subject: [PHP-WIN] Re: Page-style data display system

Daniel Anderson wrote:
, 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 * FRM 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