PHP and mySQL limit

[Bennett 🚀]

How do you limit the results for a page? and then, any leftovers be displayed like display.php?page=2 ? This is gonna be used in my user.php page of epiboards.co.cc/uStation/ , an upload station.

Thanks for any help!

[Charles Stover]

// if a page is set, and it's a number, and it's greater than 0
// use the page; otherwise, we're on page 1
$page = (array_key_exists('page', $_GET) && is_numeric($_GET['page']) && $_GET['page'] > 0 ? $_GET['page'] : 1);
$items_per_page = 10;
$results = mysql_query('SELECT `whatever` FROM `wherever` LIMIT ' . ($page - 1) * $items_per_page . ', '. $items_per_page) or die(mysql_error());

MySQL's LIMIT ability works as follows:
LIMIT x, y
Skip to the x'th result, and return y results after that.

So at page 1, we'd skip to the 0th result (which would be the first in an array; I may be wrong where LIMIT starts at 1 instead of 0, in which case you'd use ($page - 1) * $items_per_page + 1), and get 10 items after that.
Then at page 2, we'd skip to the 10th result ($page - 1) * $items_per_page = 1 * 10 = 10 and get the 10 items after that.
Then at page 3, we'd skip to the 20th result 2 * 10 = 20 and get the 10 items after that.

And there you have it. For every page, skip 10 and return the 10 after that.