From a850381ad262457940b639d0735794a19ae58f66 Mon Sep 17 00:00:00 2001 From: Karl 'vollmerk' Vollmer Date: Fri, 21 Apr 2006 07:00:33 +0000 Subject: fixed the sql file... stupid mysql_dump --- lib/song.php | 8 +------- 1 file changed, 1 insertion(+), 7 deletions(-) (limited to 'lib/song.php') diff --git a/lib/song.php b/lib/song.php index 81095cc1..5156ca88 100644 --- a/lib/song.php +++ b/lib/song.php @@ -96,17 +96,11 @@ function get_song_id_from_file($filename) { $filename = sql_escape($filename); - $sql = "SELECT id FROM song WHERE file='$filename'"; + $sql = "SELECT id FROM song WHERE file LIKE '%$filename'"; $db_results = mysql_query($sql, dbh()); $results = mysql_fetch_assoc($db_results); - if (!$results['id']) { - $sql = "SELECT id FROM song WHERE file='%$filename%'"; - $db_results = mysql_query($sql, dbh()); - $results = mysql_fetch_assoc($db_results); - } - return $results['id']; } // get_song_id_from_file -- cgit