Jump to content

Archived

This topic is now archived and is closed to further replies.

thomjjames

Alphabetic List of SQL results with each letter in a group

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

[!--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--]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.