i have an image page.. right now its showing the top 5 pictures for example.. by rating. say there are 4 files with a rating of 10, how can i make the 4 files show up randomly and different each time?
right now i have
ORDER BY i.image_rating ASC, rand(i.image_name)
this works and makes it line up randomly, but its always in that same random order. how can i make it so it will always be different?
