Re: Page-style data display system

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux