RE: Displaying news across several pages

2003-01-25 Thread Rich Gray
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

Re: Displaying news across several pages

2003-01-25 Thread Stefan Hinz, iConnect \(Berlin\)
- 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