when 2 arguments are specified for LIMIT then the first argument is the
offset and the second is the max number of rows
e.g. below
select * from mytable limit 10,10
select * from mytable limit 20,10
Rich
-Original Message-
From: Pag [mailto:[EMAIL PROTECTED]]
Sent: 25 January 2003 05:10
- Original Message -
From: Rich Gray [EMAIL PROTECTED]
To: Pag [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, January 25, 2003 12:03 PM
Subject: RE: Displaying news across several pages
when 2 arguments are specified for LIMIT then the first argument is
the
offset and the second is the max