Consistent random ordering in a MySQL query

I have a database of pictures and I want to let visitors browse the pictures. I have one "next" and one "previous" link.

But what I want is to show every visitor anther order of the pictures. How can I do that? If I will use ORDER BY RANDOM() I will show sometimes duplicate images.

Can someone help me please? Thank you!

19
задан Martijn Pieters 28 May 2011 в 09:49
поделиться