Not displaying all records on webpage?

[AdamskiR]

Hi I have a news area on our site which on the main page has the top 10 latest news items. There is also a second page for a new archive which at present displays all the news items ever. What I want is on the archive page, it to strip off the top 10 news items so it only displays the previous ones from there on.:confused: The items are coming from a sql database. Thanks Adam :)

[Paddy Boyd]

Make the change in your sql statement?

[Kschuler]

Order them by date and remove the first (or last) ten records before displaying.

[AdamskiR]

Its how I put this process into practice I didnt know how to do though... Ive sorted it by doing a for loop in the code now. Thanks