query($sql1) or die('Erreur SQL !
'.$sql1.'
'.$mysqli->error);
$t = $req1->fetch_assoc();
$title = 'Tag - '.$t['tag'];
include('include/header.php');
echo "$title
\n";
$chants = array();
$sql1 = 'SELECT * FROM '.db('chant_tags').' WHERE `tag_id` = '.$s;
$req1 = $mysqli->query($sql1) or die('Erreur SQL !
'.$sql1.'
'.$mysqli->error);
while($ct = $req1->fetch_assoc()) {
$sql2 = 'SELECT * FROM '.db('chants').' WHERE id = '.$ct['chant_id'];
$req2 = $mysqli->query($sql2) or die('Erreur SQL !
'.$sql2.'
'.$mysqli->error);
$chants[] = $req2->fetch_assoc();
}
if(count($chants)) {
usort($chants, "custom_cmp");
}
echo "\n";
foreach($chants as $c) {
$incipit = $c['incipit']?format_incipit($c['incipit']):'░░'.$c['id'].'░░';
echo '- ';
if($c['gabc'] > '') {
echo ''.$incipit."";
} else {
echo ''.$incipit.'';
}
echo ' ('.$c['version'].")
\n";
}
echo "
\n";
include('include/footer.php');
?>