real_escape_string($_GET['letter']);
} else {
die('No letter');
}
$title = 'Incipit - '.$l;
include('include/header.php');
echo "$title
\n";
if($l) {
$sql1 = 'SELECT * FROM '.db('chants').' WHERE `duplicateof` IS NULL AND `incipit` LIKE "'.$l.'%" ORDER BY incipit ASC';
} else {
$sql1 = 'SELECT * FROM '.db('chants')." WHERE `duplicateof` IS NULL AND (`incipit` LIKE '' OR UPPER(incipit) REGEXP '^[^A-Zƌ].*') ORDER BY incipit ASC";
}
$req1 = $mysqli->query($sql1) or die('Erreur SQL !
'.$sql1.'
'.$mysqli->error);
$chants = array();
while($c = $req1->fetch_assoc()) {
$chants[] = $c;
}
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');
?>