Hi all,
How do i construct a query whereby i get all rows from a table however if any of the rows has an id (primary, auto incremented feild) of say 1, 5 and 20 these rows do not display in the top 3 results?
The only time these would be in the top 3 results would be if there where only 5 or less rows in the database otherwise i want them outside the top 3 and if possible randomly placed (just the 3 rows in question, the other results would be mormal).
Any ideas?
Cheers