diff options
| author | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2007-07-02 04:57:56 +0000 |
|---|---|---|
| committer | Karl 'vollmerk' Vollmer <vollmer@ampache.org> | 2007-07-02 04:57:56 +0000 |
| commit | 9457b75fb16f05347c08b484db6fe2b848efba15 (patch) | |
| tree | 18245ab1b8a2fc7953c9fc04e541d46791737ec8 /lib/class/genre.class.php | |
| parent | d54efca7bd1ee28683506b452f58742f8a8f678f (diff) | |
| download | ampache-9457b75fb16f05347c08b484db6fe2b848efba15.tar.gz ampache-9457b75fb16f05347c08b484db6fe2b848efba15.tar.bz2 ampache-9457b75fb16f05347c08b484db6fe2b848efba15.zip | |
fixed some catalog update issues, fixed some genre pages and made the sql sort stuff for show songs work
Diffstat (limited to 'lib/class/genre.class.php')
| -rw-r--r-- | lib/class/genre.class.php | 12 |
1 files changed, 5 insertions, 7 deletions
diff --git a/lib/class/genre.class.php b/lib/class/genre.class.php index 90db7d53..c0780591 100644 --- a/lib/class/genre.class.php +++ b/lib/class/genre.class.php @@ -181,18 +181,16 @@ class Genre { /** * get_artists * This gets all of the artists who have at least one song in this genre - * @package Genre - * @catagory Class */ - function get_artists() { + public function get_artists() { - $sql = "SELECT DISTINCT(song.artist) FROM song WHERE genre='" . $this->id . "'"; - $db_results = mysql_query($sql, dbh()); + $sql = "SELECT DISTINCT(`song`.`artist`) FROM `song` WHERE `genre`='" . $this->id . "'"; + $db_results = Dba::query($sql); $results = array(); - while ($r = mysql_fetch_assoc($db_results)) { - $results[] = get_artist_info($r['artist']); + while ($r = Dba::fetch_assoc($db_results)) { + $results[] = $r['artist']; } return $results; |