$queryy = SELECT * FROM school ORDER BY school;
$result = mysqli_query($connection,$queryy);
while ($row = mysqli_fetch_array($result)) {
$letter = strtoupper($row['school'][0]);
$aGroup[$letter][] = $row;
echo $aGroup[$letter][0]."<br />";
}
?>

A
Adajesus primary school
Adams secondary school
B
bubenduf boys school
benbee primary school
best inland school
C
child care school
L
life Streams College
love and hope school

A
A
A
B
B
B
B
B
C
C
L
L
L