I have a recordset on my main pages that randomly chooses and image for the 'Image of the Moment' section by using 'ORDER BY RAND()'. This is fine and it works but I would prefer for the page to just select the next record and keep going round in order.

Any ideas?

PHP and MySQL.

--------------------------------------
www.galleryof3d.com

Attempting to convert this to a database driven site - currently all individual pages. lol