I allow my members to have their own albums, which they can upload anything there. But, the main focus of my site is fishing, and the pal was pulling random photos from anywhere so I would end up with non fishing photos being displayed in the pal. To overcome this I went in and added certain photos to the My Favorites feature in Photopost, then altered the query to pull random photos from the list in My Favorites. Works kind of like a "featured" photo and works well. (Actually, a featured photo (a list that the admin ccould create) would be great in a Photopost release. But this is about tha PAL right?
What I was wondering though, is instead of using RAND in my query, I would like it to cycle through each photo in order. In other words, the first page load pulls the first photo in the list, the second pulls the scecond, and so forth. Then when it gets to the end of the list it starts all over. Now you may ask why. Well, it seems that although pulling randomly might seem to work well, I in fact see a lot of the same photos many times more than another, some I haven't seen at all. Hence my desire to ensure that each photo is displayed equally. Any idea how I could do this without modifying the database? Thanks