is there a SUM of all views in one (sub_)Cat?

[robert_2004]

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?

I wouldn't recommend this on any categories with too many images. The performance hit shouldn't be significant enough to cause any problems on just a few hundred or so though.

$imgview = array();
$imageviews = $DB_site->query("SELECT catid, views FROM adv_gallery_images WHERE catid IN(Your catids here)");
while ($imgviews = $DB_site->fetch_array($imageviews))
{
$imgview["$imgviews[catid]"] += $imgviews['views'];
}

That enough to get you started?