SELECT photo_filename, photo_label, photo_id, photo_desc, photo_dateadded, album_id, photo_viewcnt, gallery_id FROM photo_t WHERE photo_id = #photonum# AND album_id = #albumnum#
Sorry, the photo you requested does not belong to the album you requested or is no longer available.
SELECT album_label, album_photocnt, album_createdate, album_lastupdate FROM album_t WHERE album_id = #albumnum# SELECT photo_rating_count, photo_rating_total FROM photo_rating_t WHERE photo_id = #photonum# SELECT user_id FROM gallery_t WHERE gallery_id = '#getpic.gallery_id#' SELECT user_fname, user_lname, user_email, user_city, user_state, user_country, user_display FROM user_t WHERE user_id = '#getuser1.user_id#' UPDATE photo_t SET photo_viewcnt = photo_viewcnt + 1 WHERE photo_id = #photonum# UPDATE photo_t SET photo_lastviewed = '#dateformat(now(),'yyyy-mm-dd')#' WHERE photo_id = #photonum#


[Gallery Menu]	[Create Your Own Gallery]	[Login]

Caption: #getpic.photo_label#(no caption added)

Description: #Trim(photo_desc)#(no description given)

Photo Comments

SELECT photo_comment_txt, photo_comment_date, user_id FROM photo_comments_t WHERE photo_id = #photonum# ORDER BY photo_comment_id DESC

SELECT username, userid FROM user WHERE userid = #getcomments.user_id#

On #dateformat(photo_comment_date,'mm/dd/yyyy')#, #getuser.username# said:

#photo_comment_txt#

From Album:	#getalbum.album_label#(unnamed album)
Added On:	#DateFormat(getpic.photo_dateadded,'MM/DD/YYYY')#
View Count:	#viewcount# Times
Average Rating:	#rating# (#total# Votes)
Rate Picture:	(already rated)
[Forum Codes]
Username:
Password:
Comments: characters left (HTML will be removed)