Jukebond

Παραγγελιές !!!

[insert_php] $conn=mysql_connect(“localhost”,”el240366_us”,”MqRtgT?O~~^X”);
mysql_select_db(“el240366_db”,$conn);
mysql_query(“SET NAMES ‘utf8′”);

//$sql = “SELECT DISTINCT id FROM playlist”;
$sql = “SELECT id, COUNT(id) FROM playlist GROUP BY id ORDER BY COUNT(id) DESC”;
$result = mysql_query($sql, $conn) OR die(mysql_error());
while($row = mysql_fetch_array($result))
{
$id = $row[‘id’];
$sql2 = “SELECT * FROM library WHERE id=’$id’ LIMIT 1”;
$result2 = mysql_query($sql2, $conn) OR die(mysql_error());
$row2 = mysql_fetch_array($result2);
$title = $row2[‘title’];
$composer = $row2[‘composer’];
echo “

“.$row[‘COUNT(id)’].”  επιλογές:  “.$title.”     “.$composer.”

“;
}

//while ($newArray = mysql_fetch_array($result)) {
//$id = $newArray[‘id’];
//$title = $newArray[‘title’];
//$composer = $newArray[‘composer’];
//echo $id.”
“;
//}