Chants\n"; echo "

by incipit

\n"; $sql1 = 'SELECT DISTINCT UPPER(SUBSTRING(incipit,1,1)) AS letters FROM '.db('chants')." WHERE UPPER(incipit) REGEXP '^[A-Zƌ]' ORDER BY letters ASC"; $req1 = $mysqli->query($sql1) or die('Erreur SQL !
'.$sql1.'
'.$mysqli->error); echo "
\n
\n"; echo "

by usage

\n"; $sql1 = 'SELECT * FROM '.db('chants').' WHERE `office-part` != "" GROUP BY `office-part` ORDER BY `office-part`'; $req1 = $mysqli->query($sql1) or die('Erreur SQL !
'.$sql1.'
'.$mysqli->error); echo "
\n"; $sql1 = 'SELECT * FROM '.db('tags').' t WHERE EXISTS (SELECT * FROM '.db('chant_tags').' ts WHERE t.id = ts.tag_id) ORDER BY tag'; $req1 = $mysqli->query($sql1) or die('Erreur SQL !
'.$sql1.'
'.$mysqli->error); if($req1->num_rows > 0) { echo "

by tag

\n
\n
\n"; } echo "

by source

\n"; $sql1 = 'SELECT * FROM '.db('chant_sources').' GROUP BY source'; $req1 = $mysqli->query($sql1) or die('Erreur SQL !
'.$sql1.'
'.$mysqli->error); echo "
\n"; echo '

Latest updates

'."\n"; $sql1 = 'SELECT * FROM '.db('changesets').' ORDER BY `time` DESC LIMIT 10'; $req1 = $mysqli->query($sql1) or die('Erreur SQL !
'.$sql1.'
'.$mysqli->error); $mod = array(); while($m = $req1->fetch_assoc()) { $d = date("Y-m-d",$m['time']); if(!array_key_exists($d,$mod)) $mod[$d] = array(); $mod[$d][] = $m; } foreach($mod as $d => $ml) { echo $d; echo "
\n"; } echo "
"; include('include/footer.php'); ?>