-
#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
-
Welp I found the answer to my first question on mysql.com
select * from table limit 5,10
will return rows 6-15
