Today's Playlist
Two songs playing at the same time? Ugh, the rock and roll gremlins are back again! No sooner did we fix the static-in-the-webstream problem than songs are starting to play on top of each other. We're getting to the bottom of it, but if anyone has any humane gremlin traps they're not using anymore, let us know. The request box will be back soon; thanks for your patience.
t('Time'), 'field' => 'timestamp', 'sort' => 'desc'), array('data' => t('Artist'), 'field' => 'artist'), array('data' => t('Title'), 'field' => 'title')); $plst_sql = "(SELECT artist, title, timestamp, date_format(timestamp, '%l:%i %p') as timeplayed " . "FROM wknc.log_av " . "WHERE timestamp >= curdate()) " . "UNION " . "(SELECT artist, title, timestamp, date_format(timestamp, '%l:%i %p') as timeplayed " . "FROM wknc.log " . "WHERE timestamp >= curdate()) "; $plst_sql .= tablesort_sql($plst_header); $plst_result = db_query($plst_sql); // Loop through all the records while ( $plst_records = db_fetch_object($plst_result) ) { // Build a row for the table from the data $plst_rows[] = array($plst_records->timeplayed, $plst_records->artist, $plst_records->title); } if ( count($plst_rows) ) { $plst_output = theme('table', $plst_header, $plst_rows); } else { $plst_output = "There are currently no available playlists"; } // And finally, produce the page print $plst_output; ?>
t('Time'), 'field' => 'timestamp', 'sort' => 'desc'), array('data' => t('Artist'), 'field' => 'artist'), array('data' => t('Title'), 'field' => 'title')); $plst_sql = "(SELECT artist, title, timestamp, date_format(timestamp, '%l:%i %p') as timeplayed " . "FROM wknc.log_av " . "WHERE timestamp >= curdate()) " . "UNION " . "(SELECT artist, title, timestamp, date_format(timestamp, '%l:%i %p') as timeplayed " . "FROM wknc.log " . "WHERE timestamp >= curdate()) "; $plst_sql .= tablesort_sql($plst_header); $plst_result = db_query($plst_sql); // Loop through all the records while ( $plst_records = db_fetch_object($plst_result) ) { // Build a row for the table from the data $plst_rows[] = array($plst_records->timeplayed, $plst_records->artist, $plst_records->title); } if ( count($plst_rows) ) { $plst_output = theme('table', $plst_header, $plst_rows); } else { $plst_output = "There are currently no available playlists"; } // And finally, produce the page print $plst_output; ?>
