Counting pics

[hama]

I count the pics of the gallery and display the number on the startpage of my website. It works fine with this short script:

Code Select Expand

<?php
// new Gallery DB
$_gallery = new db($_cfg['DB_SERVER'], $_cfg['DB_GALLERY_USER'], $_cfg['DB_GALLERY_PASS'], $_cfg['DB_GALLERY_NAME']);

// gallery_pics
$gallery_pics = implode('', $_gallery->fetch_first('SELECT COUNT(*) FROM cpg130_pictures AS p, cpg130_albums AS a WHERE p.aid = a.aid AND a.category <> 9'));
?>

As you see I exclude cat 9 (it's a private album and I don't want to count it).

Now I'd like to exclude two cats but 9,43 gives "bad arguments", 9 AND 43 gives no errors but counts wrong.

Can someone help please. 

... Thanks

[nol33t]

Code Select Expand


...AND a.category NOT IN ( 9, 43)


[hama]

Yes, it works!

Code Select Expand

<?php
$gallery_pics = implode('', $_gallery->fetch_first('SELECT COUNT(*) FROM cpg130_pictures AS p, cpg130_albums AS a WHERE p.aid = a.aid AND a.category NOT IN ( 9, 43)'));
?>

Thanks a lot!  

--> "Lé Toph' de Tieum - NYC ou pas NYC...that is the question" --> nice gallery!  

[hama]

--> solved

[neeth]

nice