Jump to content


Photo

Alphabetic List of SQL results with each letter in a group


  • Please log in to reply
2 replies to this topic

#1 thomjjames

thomjjames
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 30 November 2005 - 10:43 AM

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.
[/quote]
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

#2 Kris

Kris
  • Staff Alumni
  • Advanced Member
  • 2,755 posts
  • LocationThe Internet

Posted 14 December 2005 - 11:21 AM

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

#3 ryanlwh

ryanlwh
  • Staff Alumni
  • Advanced Member
  • 511 posts

Posted 14 December 2005 - 04:51 PM

[!--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--]
Please use EDIT * 100...
Please use
or [php] * 1000...

PLEASE READ THE POSTED SOLUTIONS CAREFULLY * 1000000...




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users