[Resolved] Random Display of Images

[rcoursey]

I need to display images randomly. I am using MySQL to store the path to the images which are located in their own directory.

There may be 50 - 100 images.

What is the most efficient way to grab the paths randomly?

[tsinka]

Hi,

if you want to get n images randomly out of the table you could do a

SELECT ... FROM thetable ORDER BY rand() LIMIT n