jcr
09-11-2006, 08:00 PM
Okay.. this might be a stupid question. But I'm really having a problem with this one..
Say.. This is my simple little query
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
SELECT *
FROM articles
ORDER BY article_id DESC
LIMIT 1,4
Say.. This is my simple little query
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
SELECT *
FROM articles
ORDER BY article_id DESC
LIMIT 1,4