PHP / MYsql Questions

[kurtsimons]

#1

I am creating a forum and want to show my db table on multiple pages

how can I display the second page with out querying the database for all the stuff in the first page

$request = mysql_query("select * from forum where postnum > 20 and postnum < 40")

this would work but posts get added and deleted so the ids are not in order


#2

persistant connections

if I use them can i limit the number of persistant connection so that if I get hit by 100 people all at once that I don't have 100 connections left open when I usually only need 2


thank
kurtsimons

[kurtsimons]

Welp I found the answer to my first question on mysql.com

select * from table limit 5,10

will return rows 6-15