open("SELECT artist, title
FROM songlist
ORDER BY date_played DESC
LIMIT 1 ");
while($nu = $db->row())
{
echo "
" . $nu["artist"] . " - " ;
echo " " . $nu["title"] . "
";
}
$db->open("SELECT songlist.*, queuelist.requestID as requestID
FROM queuelist, songlist
WHERE (queuelist.songID = songlist.ID)
AND (songlist.songtype='S')
ORDER BY queuelist.sortID ASC",1);
while($row = $db->row())
{
if($row["requestid"]!=0) $verz=" (Jukebox verzoek!)";
echo " Straks: ".$row["artist"]." - ".$row["title"]."$verz ";
}
?>