Thank you for the reply Bill Kellum.
I tried that already, but the position of the featured products keeps on changing on the main page when I hit refresh and also when new customer logged in.
I tried messing with the sql, deleting here and there and adding some stuff hoping for miracles, since I only have a little knowledge at all with sql.
I hope someone can shed some idea on how to make sure that the product position won't change on the main page.
Many thanks in advance.