Re: FN-FORUM: Mysql syntax help

date posted 1st May 2008 15:52

Quoting Nigel Rogers [EMAIL REMOVED]

>
> $maxRows_Albums = 3;
>
>
> which i order by recent first...
>
> $query_Albums = "SELECT * FROM albumlist ORDER BY id DESC";
>
>
> is there a way to order them whilst omitting the single most recent
> entry ie
>
> 2,3,4 rather than 1,2,3
>

Alternatively (because you're doing it in reverse order and thus the
id field isn't relevant) use

Select * FROM albumlist ORDER BY id DESC LIMIT 2,3

Which will go from the second result, and then do three further results

Alex
http://www.ozbon.com