Hi... ok, i have an SQL query that seems to work fine when I click 'test' in the recordset window, but only for a few runs in explorer.

All i want to do is choose a record at random to display a different product on the home page. Here's what I'm using ...

SELECT productID, maintitle, smalltitle, prodname, mainimage, comment, detail, signuplink, ppm, ppa FROM products ORDER BY rnd(productID)

so it works a few times in explorer, then just seems to stick with the same product.

different ISP's return the same result.

any ideas??!

Thanks

Rich...<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Party On!

Rich...<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>