# of queries per page

[Anon]

How can I do this? I am wanting 15 queries to display on each page and have links to the next or previous page.

Thanks

[Anon]

make your select similar to this:

select * from table limit 0,20

the limit will show the first 20 entries, then if you want to show the next 20, you would limit 21,20 (21 = offset, 20 = num of rows to return) ... note: first record is 0, not 1..

check out http://www.mysql.com/doc/S/E/SELECT.html for additional info and examples..

John

[Anon]

Ok, that sounds correct except the math part. If the first record is 0 and you are displaying 20 then that should display records 0-19. So the second 20 would be a limit of 20,20. right?

[Anon]

If you want to have NEXT 1 2 3 4 PREV type links, see this article:

http://phpbuilder.com/columns/rod20000221.php3

---

http://sabyo.ath.cx

[Anon]

Exactly .. I fired off that reply a bit too quick -- my error.

In anycase, hope that helps out in your script.

John

[Anon]

Doesn't work under MS Access.
Any Alternative solution?