Quote:
Originally Posted by Kahuna900
Okay, I added the following to both SELECT statements located in all_albums.php:
Code:
AND album.visible > 0
Now it doesn't show any empty albums!
|
Where exactly in the two Select statements?...I added it at the end on both and got an error, ie:
$albumcount = $db->query_first("
SELECT COUNT(*) AS total
FROM " . TABLE_PREFIX . "album
WHERE state IN ('" . implode("', '", $state) . "')
AND album.visible > 0
");