Posted by John Nichel on 01/19/06 20:28

Jeffrey Pearson wrote:
> OK. I know I did this a LONG time ago but I don't remember how I did
> it. Thus, my post.
>
> I have a list of last names from a MySQL database. I need to display
> them grouped by the first letter of their last names and insert a
> separator on display. Similar to a phone book. So it looks like;
>
>
> A
> ___
> Adams
> Apple
> Army
>
> B
> __
> Banjo
> Bank
> Bark
>
> C
> __
> Captain
> Car
>
>
>
> Is there a way without jumping through too many hoops?
>
> Thanks for any input you can give.
>

Order them with your query

select * from db.table order by table.lastname ASC

--
John C. Nichel IV
Programmer/System Admin (ÜberGeek)
Dot Com Holdings of Buffalo
716.856.9675
jnichel@dotcomholdingsofbuffalo.com

[Back to original message]