[ProtoPC]

Originally Posted by CPB123

Okay I think you're getting closer - since you have a table prefix of vb_ try this

$albumcount = $db->query_first("
SELECT COUNT(*) AS total
FROM " . TABLE_PREFIX . "album
WHERE state IN ('" . implode("', '", $state) . "')
AND vb_album.visible > 0
");

but leave the second SELECT statement as album.visible don't change that one to vb_album.visible and see what happens

Thank you! That fixed it.