[Resolved] alphabetical loops?

[happyme]

I want to display a table of names like this:

A Andrew
Amanda

B Ben
Bernard

E Emma
Edward

I know how to display all the names in a MySQL database that begin with a given letter, but how do I generate an alphabetical loop?
I could create a MySQL table with one column containing the alphabet but I'm sure there must be a simple way. Can I use ASCII codes?

Julia

[barand]

If you want to list all letters, even if no names

for ($c=ord("A"); $c<=ord("Z"); $c++) {
$f = chr($c);
//select and list names begining with $f
}

otherwise

select name from table order by name
last_initial=""
while (...) {
$initial = substr($name,0,1);
if ($initial != $last_inital) echo "$initial ";
echo "$name<br>";
$last_initial = $initial;
}

[happyme]

thank you!

now why didn't I think of that?

🙂

Julia