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? <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /><br /><br />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

Well you can pull photos in this pal based on random recent or most views. <br /> <br />Adding AND cattype='c' into the query will only pull cat photos not album photos and is a minor edit <br /> <br />As far as adding pagination thats a whole different story yes this is a pal box. <br /> <br />Basically to do something like you want you would need to create a showgallery lite script almost <img src="http://www.ubbdev.com/forum/images/graemlins/wink.gif" alt="" /> <br /> <br />I have one site http://www.innertraveler.com/publicgallery where I made a pagination featured photo addition <br /> <br />You will see what I mean by showgallery lite <img src="http://www.ubbdev.com/forum/images/graemlins/wink.gif" alt="" /> that featured photo block displays like the last 240 images with page navigation 24 to a page on there main Photopost index. <br /> <br />If you want a copy of that featured script to play with and modify just let me know.

That's very nice, but not what I'm looking for, though I may want to check it out later.<br /><br />As far as using the cattype=c, some of my users put all of their photos in their album, where as others just add to the main category. So, in order to display from both I changed the query to pull from my favorites list, then went and added the better pics to my list. I only want on location shots displayed in the PAL see, and some pics are taken after getting home and they're cleaning fish, and some are better than others, etc.<br /><br />Basically, instead of showing random photos in the PAL, I simply want to display them in order. Am I making any sense? Sometimes I confuse myself. <img src="http://www.ubbdev.com/forum/images/graemlins/grin.gif" alt="" />

So you want to display all photos in order from recent to oldest.<br /><br />okay got that<br /><br />Now how do you want them sorted?

I don't really need them sorted. Just one photo displayed in the PAL.<br /><br />ex.<br /><br />page loads, photo #1 is displayed<br />page loads again, photo # 2 is displayed<br />page loads again, photo #3 is displayed<br />if there are a total of three photos in the list and photo #3 was the last one, the next time the page is loaded it starts all over again with photo #1 and so forth.<br /><br />I was thinking of a loop. There would be a check to see if there was a variable set, if not then pull the first photo in the list. If it was set, add 1. Query the data base. Count the number of rows. If the number is more than the sum of rows..... pull the first phot, if not then grab that number pic. But then there's the case of a deleted row and how to pass the variable from page to page. um... You know what? Maybe it's more trouble than it's worth. <img src="http://www.ubbdev.com/forum/images/graemlins/crazy.gif" alt="" /> I know what I want, but I don't think there's an easy way to do it. Thanks anyway. I'll mull over it a while and get some other things done. Maybe something will go off in my head. <img src="http://www.ubbdev.com/forum/images/graemlins/grin.gif" alt="" />

Hmmm tried to do this one...<br /><br />First I get this ..<br /><br />Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in g:\webs\www.bm3w.co.uk\public_html\ubbthreads\pals\custombox1pal.php on line 57<br /><br />Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in g:\webs\www.bm3w.co.uk\public_html\ubbthreads\pals\custombox1pal.php on line 82<br />Featured Photos<br />Could not select database 'DATABASE'<br /><br />So, I amend "DATABASE" in the custompal as clearly its not getting the variable, and then I just get <br /><br />Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in g:\webs\www.bm3w.co.uk\public_html\ubbthreads\pals\custombox1pal.php on line 57<br /><br />Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in g:\webs\www.bm3w.co.uk\public_html\ubbthreads\pals\custombox1pal.php on line 82<br /><br />and no pictures...<br /><br />Whats wrong?? thanks <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />