To get the select results sorted randomly, you have to use the newid() function. This is an example:

select top 10 * from PhotoList order by newid()

It will return random selection from the entire select set for each consecutive execution.