Re: FN-FORUM: Mysql syntax help

date posted 1st May 2008 16:04

Quoting Nigel Page [EMAIL REMOVED]

>
> Try SELECT * FROM albumlist ORDER BY id DESC LIMIT 2,3
>
> 2 is the start row, 3 is the rows to return.
>
> Nigel.


Oops (and in my response that said the same thing) - Using Limit and
the offset, record #1 is actually offset 0, so you need

LIMIT 1,3 , not (the instinctive) 2,3

http://dev.mysql.com/doc/refman/5.1/en/select.html explains

Alex
http://www.ozbon.com