total images?

[Jasondavis]

Is there a way to display the Total number of images in my Gallery on my main site, totaly seperate from the gallery? I have a link that says Gallery I would like to have a thing next to it that says (190 images) and have it update itseld as I add pics

[V@no]

try this:

Code: [Select]

<?php
define&#40;'ROOT_PATH', './4images/'&#41;;// PATH to your 4images Gallery / PFAD zu Ihrer 4images Gallerie'
include&#40;ROOT_PATH.'config.php'&#41;;
include&#40;ROOT_PATH.'includes/db_mysql.php'&#41;;
include&#40;ROOT_PATH.'includes/constants.php'&#41;;
$site_db = new Db&#40;$db_host, $db_user, $db_password, $db_name&#41;;
$sql = "SELECT COUNT&#40;*&#41; as total_images
        FROM ".IMAGES_TABLE." a, ".CATEGORIES_TABLE." b 
        WHERE a.image_active=1 
        AND a.cat_id = b.cat_id 
        AND b.auth_viewcat=".AUTH_ALL." 
        AND b.auth_viewimage=".AUTH_ALL."
        ";
$row = $site_db->query_firstrow&#40;$sql&#41;;
$total_images = $row['total_images'&#93;;
echo $total_images;
?> change ./4images/ to your 4images dir.

[Jasondavis]

Hi I tried it, my index usses SSI so I saved the code u posted as a .php file and included it with severside includes. That almost works, my problem is it dislays the number "0" but im my gallery I have 202

[Jasondavis]

Hi any ideas from anyone? All that is displayed is 0 when I do this!
I would love any help thank you
-Jason

[Jasondavis]

to the top^