//Create old school procedural connection to mysql
$con = mysql_connect("127.0.0.1", "sql", "sql");
//If I can't connect, die
if (!$con) {
die('Could not connect: ' . mysql_error());
}
//Select DB
mysql_select_db("crowdsound", $con);
//Query String
$sql = "SELECT * FROM local_data ORDER BY RAND() LIMIT 5";
//Query
$q = mysql_query($sql, $con);
$track_array = array();
//Find rdio tracks
while ($r = mysql_fetch_assoc($q)) {
$rdio_track = $rdio->searchTracks($r['artist_name'], $r['track_name']);
foreach ($rdio_track->result->results as $result) {
$track_id = $result->artistKey;
}
$track_array[] = array('artist' => $r['artist_name'], 'track' => $r['track_name'], 'rdio_id' => $track_id);
}
?>
<html>
<head>
<title>Crowd Sound</title>
<meta charset="utf-8" />
<link rel="stylesheet" href="css/style.css" />
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.6.4/jquery.min.js"></script>
<script src="Rdio.js"></script>
<script type="text/javascript">
