diff options
| author | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2007-09-05 01:54:51 +0000 |
|---|---|---|
| committer | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2007-09-05 01:54:51 +0000 |
| commit | 7b89ee50023a4a8ea60e9bc1789072d6a1db91e9 (patch) | |
| tree | 811719b74a218c711bd6a5d9de2b744cabd04801 /lib | |
| parent | 805d273b0f41ba55027babaeff01845d7bd04d64 (diff) | |
| download | ampache-7b89ee50023a4a8ea60e9bc1789072d6a1db91e9.tar.gz ampache-7b89ee50023a4a8ea60e9bc1789072d6a1db91e9.tar.bz2 ampache-7b89ee50023a4a8ea60e9bc1789072d6a1db91e9.zip | |
fixed album/artist/whateva editing, fixing stats, fixed search...
Diffstat (limited to 'lib')
| -rw-r--r-- | lib/class/catalog.class.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/lib/class/catalog.class.php b/lib/class/catalog.class.php index 943f18f4..4b8a854d 100644 --- a/lib/class/catalog.class.php +++ b/lib/class/catalog.class.php @@ -237,17 +237,17 @@ class Catalog { $time = $data['1']; $size = $data['2']; - $sql = "SELECT COUNT(`album`) FROM `song` $catalog_search GROUP BY `album`"; + $sql = "SELECT COUNT(DISTINCT(`album`)) FROM `song` $catalog_search"; $db_results = Dba::query($sql); $data = Dba::fetch_row($db_results); $albums = $data['0']; - $sql = "SELECT COUNT(`artist`) FROM `song` $catalog_search GROUP BY `artist`"; + $sql = "SELECT COUNT(DISTINCT(`artist`)) FROM `song` $catalog_search"; $db_results = Dba::query($sql); $data = Dba::fetch_row($db_results); $artists = $data['0']; - $sql = "SELECT COUNT(`genre`) FROM `song` $catalog_search GROUP BY `genre`"; + $sql = "SELECT COUNT(DISTINCT(`genre`)) FROM `song` $catalog_search"; $db_results = Dba::query($sql); $data = Dba::fetch_row($db_results); $genres = $data['0']; |