View Full Version : Member galleries last photo upload image problem
August 1st, 2005, 06:57 PM
When I go to member galleries, under the "Last photo uploaded" column it shows the correct date of the last photo uploaded, but the image shown is actually the first photo uploaded. I would like it to show the most recent photo uploaded, i.e. the actualy last photo uploaded. How do I get it to this?
Here is my site: http://www.scrapbookingswede.com/gallery/showmembers.php?cat=500
August 1st, 2005, 07:21 PM
As discussed on the forums here it is a known thing with the members gallery area. Basically because using a GROUP BY user statement to group things for a members gallery area you cant grab the last photo on the main query
We use to issue a second query to grab the last photo but that involves a query for every single entry on the page which means if you display 12 users a page 12 extra queries which is not efficient. We are looking at other ways of dealing with this in an efficient matter
August 1st, 2005, 07:25 PM
Thank you very much for your quick reply. I appreciate the response. Thought the problem was with something I had set in the admin - now I understand! Thanks again!
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.