PHP MySQl : Alphabetical Ordered list with Heading and anchored link with aplabets -

i trying on alphabetical ordered list alphabets heading linked list of alphabets @ top of table.

instance:
- c - d - f - g ............

a alabama alaska  california colorado connecticut  d delaware  f florida  etc. 

as see letters "b" , "e" missing not exist in table.

any appreciated , others too.

thanks lot.

select substring(statename, 1, 1) state_init, group_concat(statename, ",") usstates group state_init; 

might give starting point