rendered paste body<?
require("SAMconfig.php");
$db->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);
?>
<?
$numbers = range(1, 8);
srand((float)microtime() * 1000000);
shuffle($numbers);
while(list($key, $song) = each($queue))
{
foreach ($numbers as $number) {
echo "<span class=\"$number\">* ";
if(empty($song["artist"]))
$song["artist"] = 'Unknown';
echo $song["artist"];
echo " - ";
echo $song["title"];
echo "<br></span>";
}
}
/* while(list($key, $song) = each($queue))
{
echo "<span class=\"$number\">* ";
if(empty($song["artist"]))
$song["artist"] = 'Unknown';
echo $song["artist"];
echo " - ";
echo $song["title"];
echo "<br></span>";
}*/
?>