[jcr]

Okay.. this might be a stupid question. But I'm really having a problem with this one..

Say.. This is my simple little query

PHP Code:

SELECT *
FROM articles
ORDER BY article_id DESC 


What I want further is that it skips the FIRST result, and only shows the articles from row 2 and so forth.

See: www.exsite.no/index.php and / or the attached image to see what I mean.

It's in Norwegian but I'm sure you'll get the picture. The main article shows up two places. In the row below I want the results to start with the next row instead of from the beginning.

(made with a loop function in Dreamweaver MX )

Could someone please rewrite the above query to make it "skip to the next row"?


EDIT I FIGURED IT OUT

This did it

PHP Code:

SELECT *
FROM articles
ORDER BY article_id DESC
LIMIT 1,4