From 0b4e8ed38c7543f14b703600be165b68f999a4db Mon Sep 17 00:00:00 2001 From: Karl 'vollmerk' Vollmer Date: Thu, 28 Dec 2006 02:01:46 +0000 Subject: fixed WMP11 Now Playing, broke Album Art gathering, re-writing to fix some serious logic flaws --- lib/song.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'lib/song.php') diff --git a/lib/song.php b/lib/song.php index 8aa24ead..57fab392 100644 --- a/lib/song.php +++ b/lib/song.php @@ -56,7 +56,7 @@ function get_songs_from_type($type,$results,$artist_id='') { $type = sql_escape($type); - $sql = "SELECT id FROM song WHERE "; + $sql = "SELECT id FROM song WHERE ("; foreach ($results as $value) { $value = sql_escape($value); @@ -64,9 +64,9 @@ function get_songs_from_type($type,$results,$artist_id='') { } // Run the long query - $sql = rtrim($sql,'OR '); + $sql = rtrim($sql,'OR ') . ')'; $sql .= " ORDER BY `track`"; - + $db_results = mysql_query($sql,dbh()); while ($r = mysql_fetch_assoc($db_results)) { -- cgit