pagination in php

Question

1 - 25 of 414 records Next >

I am using 3 inputs frm user ant it is same as link provided above

possible duplicate of [Pagination for PHP search results](http://stackoverflow.com/questions/4244006/pagination-for-php-search-results) — OMG Ponies, Feb 01 '11 at 00:31

score 1 · Answer 1 · answered Feb 01 '11 at 00:24

1

Use MySQL's LIMIT and OFFSET constructs:

$offset = ($current_page - 1) * $items_per_page;
// in your query:
LIMIT $items_per_page OFFSET $offset

answered Feb 01 '11 at 00:24

ThiefMaster

score 1 · Answer 2 · answered Feb 01 '11 at 00:31

1

I'd check out the Pager class in the PEAR repository. It's what I use for this sort of thing, and it has a bunch of options you can set.

answered Feb 01 '11 at 00:31

barfoon

2 Answers2