Alphabetic List of SQL results with each letter in a group

[thomjjames]

Hi everyone,

 

i was wondering if anyone out there knows how to list mySQL results in alphabetical order with each letter having its own group [probably doesn't make much sense, so...].

 

So for example it would look like this:

 

[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]

A

All the people whos name begins with A.

 

B

All the people whos name begins with B.

 

C

All the people whos name begins with C

 

and so on and so on.

The only way i know how to do this would be to make separate recordsets for each letter of the alphabet [abit long winded] and i was hoping someone might know how to do this with a for loop or something similar.

 

 

any suggestions would be brilliant

 

 

Thanks

TOM

[zq29]

This has absolutly nothing to do with core PHP hacking. Moved to our MySQL forum.

[ryanlwh]

[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] name, LEFT(name,1) AS initial FROM people ORDER BY initial ASC, name ASC [!--sql2--][/div][!--sql3--]