You need running the " burthold's" photoablum 1.82mod

and you'll need to edit inc_latestalbumthumb2.asp

Edit the address (in RED)


And you may have to remove the following part in RED

Of course if you have configered to upload to a different file, then you'll have to change from albums (default) to your new folder.
Helter<

Thanks David, glad you got it working<

In inc_latestalbumthumb2.asp

replace line 39 with the following code.
This will now call the text formatting of the forum.
Helter<

No probs. Just need the download file reziped at some point.<

Originally posted by Classicmotorcycling
OK, found a slight issue with the code. The actual photos do not update on the front page. I will give an example:

I have set the display to 10 photos (on a site not for the public) and
it displays the first 10 users in alphabetical order (which will
consist of say 3 users starting with A, 4 starting with D, 2 starting
with F and 1 with H), but when a user with a name that starts with I
or above updates their photo album, the photos do not change on the
front page. In other words their phot doesn't show on the front page.
Any help getting this resolved would be great.

Try changing the SQL statement to use TOP for Access and LIMIT for SQL
and if you order by the primary key in a descending fashion you should
get the last 10 entries made to the table. Something like this:

SELECT TOP 10 FORUM_ALBUM.Photo_id, FORUM_ALBUM.Photo_Name AS ID,
FORUM_ALBUM_USERS.M_NAME, FORUM_ALBUM.Member_id
FROM FORUM_ALBUM, FORUM_ALBUM_USERS
WHERE (((FORUM_ALBUM.Member_id)=[FORUM_ALBUM_USERS].[MEMBER_ID]) AND
((FORUM_ALBUM.Photo_Status)=1))
GROUP BY FORUM_ALBUM.Photo_id, FORUM_ALBUM.Photo_Name,
FORUM_ALBUM_USERS.M_NAME, FORUM_ALBUM.Member_id
ORDER BY FORUM_ALBUM.Photo_id DESC;



<