top.php


<head>
	<meta content='width=device-width, initial-scale=1' name='viewport'/>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>

<body bgcolor="#EBEBEB">

<?php
try
{
	$db = new PDO('sqlite:library.db');
}
catch (Exception $e)
{
	die('Erreur : ' . $e->getMessage());
}

$reponse = $db->query('SELECT playlist.title, songs.vote FROM playlist INNER JOIN songs ON playlist.info=songs.id WHERE songs.played = (SELECT MIN(played) FROM songs) AND vote > 0 ORDER BY songs.vote DESC LIMIT 10');
while ($song = $reponse->fetch())
{
	
	echo $song[0] . ' ' . $song[1] . '</br>';

}

$reponse->closeCursor();
?>

</body>