Location: PHPKode > projects > Radio404 > radio404/htdocs/lastten.php
<?php
/********************************************************************
This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either
version 2 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied
warranty of MERCHANTABILITY or FITNESS FOR A
PARTICULAR PURPOSE. See the GNU General Public
License for more details.
You should have received a copy of the GNU General
Public License along with this program; if not, write to
the Free Software Foundation, Inc.,
 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
********************************************************************/

/**
 * Purpose: page to show the 10 last played tracks
 */

require('../sql.inc');
require('functions.php');

$sql = "SELECT t.track AS track, h.stamp AS time FROM tracks t, history h WHERE t.id = h.tid ORDER BY h.id DESC LIMIT 10";
$result = sql_query($sql);

$i = 1;

foreach($result AS $track)
{
	$tracks = get_track_info($track->track);
	echo $i . ') ' . $tracks['song'] . ' by ' . $tracks['artist'] . ' at ' . date('F j, Y, g:i a', $track->time) . '<br />
';

	$i++;
}

?>
Return current item: Radio404