Re: FN-FORUM: Mysql syntax help

date posted 1st May 2008 15:50

I'd personally do the simple option of sticking LIMIT 4 on the end and
just ignoring the first row.

Martin

On 01/05/2008 17:17, Nigel Rogers wrote:
>
> Hi, I think this is a simple question:
>
>
> I have a simple query that requests the 3 most recent album entries from
> a mysql database
>
> $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
>
>
> Any help or a pointer to even the right google search term would be most
> appreciated.
>
>
> Many thanks in advance
>
> Nigel
>
> ps or is there only me on the forum today, it is quiet?
>