NextGen - Display Image Count Per Gallery

Question

I am using the NextGen gallery WordPress plugin for a site. In my gallery.php template I want to retrieve the number of images for each gallery displayed in the loop. I cannot figure out a way to get the data and print it under the thumbnail of each gallery that's called in gallery.php

Here is where I want to insert the gallery image count and print it:

<?php 
global $wpdb; 
$images = intval( $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->nggpictures") ); ?> 
<a rel="prettyPhoto" href="<?php echo $image->imageURL ?>" <?php $image->thumbcode ?>>
    <span>view</span>
</a>
<?php echo $images; ?> pictures

Answer 1

Using your above code, you were just missing the WHERE clause. Hopefully that should work.

<?php 
global $wpdb; 
$images = intval( $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->nggpictures WHERE galleryid = {$gallery->ID}") ); ?> 
<a rel="prettyPhoto" href="<?php echo $image->imageURL ?>" <?php $image->thumbcode ?>>
    <span>view</span>
</a>
<?php echo $images; ?> pictures

It's not the best way to implement it, but if it works for you :)

Answer 2

if ( $postid !='' ) {
    $set = ci_featgal_get_attachments();
    $i = 0;
    while ( $set->have_posts() ) : $set->the_post();
        get_template_part( 'loop' ); 
        $i++;
    endwhile; 
    wp_reset_postdata(); 
    ?><h6 style="font-size:10px;color:#c9b07d;"><?php echo $i ." PHOTOS";?></h6><?php
}