PhotoPost Community - View Single Post - is there a SUM of all views in one (sub_)Cat?

robert_2004 · January 13th, 2005, 01:39 PM

i'm looking for something along the lines of: $totalviews['catid']

so i can display a SUM of every image view, combined for the one sub_category.

i.e. if i have 5 photos with, 23 views, 48 views, 162 views, 28 views, 100 views,

then my total views for the cat is: 361.

(i hope that's explained well enough)

is there already a $var available, or is it easy to create? also, would the sql query be too intensive for a view of (example) 20 sub cats on page, each with 120 images?

January 13th, 2005, 01:39 PM	#1 (permalink)
robert_2004 Member Verified Customer Join Date: Oct 2004 Posts: 151	is there a SUM of all views in one (sub_)Cat? i'm looking for something along the lines of: $totalviews['catid'] so i can display a SUM of every image view, combined for the one sub_category. i.e. if i have 5 photos with, 23 views, 48 views, 162 views, 28 views, 100 views, then my total views for the cat is: 361. (i hope that's explained well enough) is there already a $var available, or is it easy to create? also, would the sql query be too intensive for a view of (example) 20 sub cats on page, each with 120 images?