(T) Traduction disponible - Télécharger un extrait.
Cliquez sur la pochette d'un album pour voir ses détails.

"; $requete_album = mysql_query("SELECT * from discographie where type='cd' order by titre"); $nbr_albums = mysql_numrows($requete_album); $i_album = "0"; WHILE ($i_album != $nbr_albums) { $id_album = mysql_result($requete_album,$i_album,"id"); $titre_album = mysql_result($requete_album,$i_album,"titre"); $pochette_album = mysql_result($requete_album,$i_album,"pochette"); echo "

"; echo lien("","discographie.php?page=lire&id=$id_album","Voir les détails de cet Album"); echo " $titre_album

"; $requete_chansons = mysql_query("SELECT * from chansons order by titre"); $nbr_chansons = mysql_numrows($requete_chansons); $i_chansons = "0"; WHILE ($i_chansons != $nbr_chansons) { $id_chanson = mysql_result($requete_chansons,$i_chansons,"id"); $titre_chanson = mysql_result($requete_chansons,$i_chansons,"titre"); $albums_chanson = mysql_result($requete_chansons,$i_chansons,"albums"); $traduction = mysql_result($requete_chansons,$i_chansons,"contenu_traduction"); $extrait = mysql_result($requete_chansons,$i_chansons,"extrait"); $albums_chanson = explode(',',$albums_chanson); if (in_array($id_album,$albums_chanson)) { echo lien($titre_chanson,"$self?page=lire&id=$id_chanson","$titre_chanson"); echo " "; if ($traduction != "") { echo "(T) "; } if ($extrait != "") { echo lien("","extraits/$extrait","Télécharger un extrait de cette chansons"); } echo "
"; } $i_chansons++; } echo "

"; $i_album++; if ($i_album != $nbr_albums) { echo "

"; } } $requete_bootleg = mysql_query("SELECT * from chansons where albums='0'"); $nbr_bootleg = mysql_num_rows($requete_bootleg); if ($nbr_bootleg != "") { echo "

Autres chansons.

"; $i = "0"; WHILE ($i != $nbr_bootleg) { $id_chanson = mysql_result($requete_bootleg,$i,"id"); $titre_chanson = mysql_result($requete_bootleg,$i,"titre"); $traduction = mysql_result($requete_bootleg,$i,"contenu_traduction"); $extrait = mysql_result($requete_bootleg,$i,"extrait"); echo lien($titre_chanson,"$self?page=lire&id=$id_chanson","$titre_chanson"); echo " "; if ($traduction != "") { echo "(T) "; } if ($extrait != "") { echo lien("","extraits/$extrait","Télécharger un extrait de cette chansons"); } echo "
"; $i++; } echo "

"; } } // LIRE if ($page == "lire") { $titre_chanson = req_id("chansons","titre",$id,"0"); $auteur_chanson = req_id("chansons","auteur",$id,"0"); $albums_chanson = req_id("chansons","albums",$id,"0"); $contenu_chanson = contenu_mep(req_id("chansons","contenu",$id,"0"),"0"); $contenu_traduction_chanson = contenu_mep(req_id("chansons","contenu_traduction",$id,"0"),"0"); $commentaire_chanson = contenu_mep(req_id("chansons","commentaire",$id,"0"),"0"); if ($contenu_traduction_chanson == "") { $contenu_traduction_chanson = "Traduction non disponible"; } echo titre($titre_chanson); echo "

"; if ($auteur_chanson != "") { echo "Auteur : $auteur_chanson
"; } echo "Albums : "; echo albums($albums_chanson); echo "

Paroles

Traduction

$contenu_chanson

$contenu_traduction_chanson

"; echo "

$commentaire_chanson

"; } include 'interface_bas.php'; ?>