SELECT from table first 20 rows .. how ?

[aaron888]

Hi,

My table has like 200 over rows.

But I only wanna display the first 20 rows.
Then at the bottom, I want to put a "NEXT" link, where if the user clicks next, it shows the next 20 rows and so on...

Any idea how to do that ?
I tried searching around.... but I am such a newbie... not really sure of good resources. lol

Thanks all.

[joaquin_win]

Check Sitepoint's tut Perfect Pagination: http://www.sitepoint.com/article/per...hp-pagination/

[r937]

if you're using mysql, check out the LIMIT option of the SELECT statement

make sure you have an ORDER BY clause, and then use:

LIMIT $rowstoskip, $rowstoprint

[whizkid00]

use LIMIT offset, Number

For first 20, offset=0, Number=20

[JREAM]

SELECT FROM place WHERE `id`='0' LIMIT 20
Then next page:
SELECT FROM place WHERE `id`='21' LIMIT 20

cant you do that??

nevermind if the IDs arent perfectly in a row itll get jumbled

[UFTimmy]

SELECT FROM place WHERE `id`='0' LIMIT 20
Then next page:
SELECT FROM place WHERE `id`='21' LIMIT 20

cant you do that??

nevermind if the IDs arent perfectly in a row itll get jumbled

Assuming the id is the primary key, that'll just return one row.

[aaron888]

ok, thanks everyone for all the tips.

joaquin_win also shared some very good resource, and I am gonna be using that.