open("SELECT songlist.*, queuelist.requestID as requestID FROM queuelist, songlist WHERE (queuelist.songID = songlist.ID) AND (songlist.songtype='S') AND (songlist.artist <> '') ORDER BY queuelist.sortID ASC",10); $queue = $db->rows(); reset($queue); ?> * "; if(empty($song["artist"])) $song["artist"] = 'Unknown'; echo $song["artist"]; echo " - "; echo $song["title"]; echo "
"; } } /* while(list($key, $song) = each($queue)) { echo "* "; if(empty($song["artist"])) $song["artist"] = 'Unknown'; echo $song["artist"]; echo " - "; echo $song["title"]; echo "
"; }*/ ?>