[SOLVED] show records 5-8 inclusive?

[delphi123]

Hi,

 

I've got the following code:

 

$query = ("SELECT news_id, category, title, text, img_url, linkto, DATE_FORMAT(date,'%d %M, %Y') as sd FROM news_posts ORDER BY date DESC LIMIT 4") or DIE ("Can't retrieve");

 

showing the latest four posts by date.

 

Elsewhere in the site I'd like to show the next four (ie posts 5,6,7,8 )

 

Can anyone show me how my SQL can be modified to do this?

[~n[EO]n~]

LIMIT 4, 5

will fetch 4 records starting from the 5th row

[delphi123]

super!