Well thats handled automatically using the LIMIT clause.
If you do:
SELECT * FROM Table ORDER BY isNew DESC LIMIT 1,5
....you'll get your first five new links, then:
SELECT * FROM Table ORDER BY isNew DESC LIMIT 6,5
...will show your remaining non new links.
If you do:
SELECT * FROM Table ORDER BY isNew DESC LIMIT 1,5
....you'll get your first five new links, then:
SELECT * FROM Table ORDER BY isNew DESC LIMIT 6,5
...will show your remaining non new links.
