FN-FORUM: Mysql syntax help

date posted 1st May 2008 15:41

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?