Re: FN-FORUM: Mysql syntax help

date posted 1st May 2008 15:57

Try SELECT * FROM albumlist ORDER BY id DESC LIMIT 2,3

2 is the start row, 3 is the rows to return.

Nigel.
----- Original Message -----
From: "Nigel Rogers" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Thursday, May 01, 2008 5:17 PM
Subject: FN-FORUM: Mysql syntax help


>
> 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?
>
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>