Alphabetic List of SQL results with each letter in a group
Posted 30 November 2005 - 10:43 AM
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--]
All the people whos name begins with A.
All the people whos name begins with B.
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
Posted 14 December 2005 - 11:21 AM
Posted 14 December 2005 - 04:51 PM
or [php] * 1000... PLEASE READ THE POSTED SOLUTIONS CAREFULLY * 1000000...
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users