$Valeur) { if ($Cle == 'TypeFilm') {$TypeFilm = $Valeur;} if ($Cle == 'Annee') {$Annee = $Valeur;} }*/ $sql = "SELECT Distinct Album FROM BD_Titres order by Album"; $resultat = mysql_query($sql); $nbEnreg = mysql_num_rows($resultat); $nbChamps = mysql_num_fields($resultat);while ($ligne = mysql_fetch_array($resultat)){ echo "" . $ligne["Album"] . "
"; $sql2 = "SELECT concat(right(concat('00',Numero),2), ' - ', Titre, ' (', ifnull(Annee,'-'), ') ', "; $sql2 .= "CASE ifnull(PremiereEdition,'') "; $sql2 .= "WHEN '1' THEN '(Premiere Edition)' ELSE '' END, "; $sql2 .= "CASE isnull(Pret) WHEN 1 THEN '' ELSE concat(' Prété ŕ : ', Pret, '') END "; $sql2 .= ") Titre FROM BD_Titres where Album = '".$ligne['Album']."' order by Numero"; $resultat2 = mysql_query($sql2); while ($ligne2 = mysql_fetch_array($resultat2)) { echo $ligne2["Titre"] . "
"; } echo "
"; }?>